Patch My PC Ideas & Feedback

A community where customers and the community can provide feedback to make a better product for everyone! For more details on how we prioritize requests, please see:

Add a new idea Subscribe
0 VOTE
Status SHIPPED
Categories Patch My PC Publisher
Created by Casey O'Rourke
Created on Sep 10, 2019

RELATED IDEAS

Publishing Service Generate/Append CSV File On Sync

So the SCCM environment I've built out for application patching runs two concurrent components: 1. Software Update ADRs that pull from PMPC; 2. Compliance Baselines reporting versions of installed applications. I want to automate every piece I possibly can, and currently the big target is the Compliance Baselines, which require version numbers to be updated by hand each update cycle.

 

So, what would be nice is for PMPC Publishing Service to generate and then optionally append a simple CSV file for the applications, including metadata like publisher, file version, and applicable CVEs.

 

Is this feasible?

  • Attach files
      Drop here to upload
    • Casey O'Rourke
      Reply
      |       Oct 4, 2019

      Justin, here's a really rough idea of what the output might look like. Disregard the bold text formatting for the header. That is just for highlighting the header. CSV obviously doesn't allow text formatting. :-)

      PMPC_CSV_Idea.png
      PMPC_CSV_Idea.png
    • Casey O'Rourke
      Reply
      |       Oct 3, 2019

      Justin, let me throw something together and send it to you.

      Casey O�Rourke
      Systems Engineer, Infrastructure
      121 NW Everett Street, Portland, OR 97209
      OFFICE +1 5035485024 | CELL | FAX 503-639-7873

    • Admin
      Justin Chalfant
      Reply
      |       Oct 3, 2019

      Send me a preview if you want to try an internal preview build.

    • Casey O'Rourke
      Reply
      |       Oct 3, 2019

      @Justin Looks good. Adding the column for what action PMPC has taken was a good addition. Just make sure the final version has column headers (obviously). :-)

    • Admin
      Justin Chalfant
      Reply
      |       Oct 3, 2019

      Something like this look good?

      123.PNG
      123.PNG
    • Casey O'Rourke
      Reply
      |       Oct 1, 2019

      @Justin Nothing more to add in there. Those 5 columns are the ones needed.

    • Casey O'Rourke
      Reply
      |       Oct 1, 2019

      @Justin Off the top of my head,

      • Application Name (just name, no version number),

      • Update Released/Revised,

      • Version Number (preferably, when possible, in the four octet format used by Powershell [version] variable casting),

      • Severity,

      • CVEs (leave the cell empty if not applicable).

      Let me consult with my SecOps person to see if they would like anything else.

    • Admin
      Justin Chalfant
      Reply
      |       Oct 1, 2019

      @Casey, we are starting to look into this request now. For published updates, could you please let us know what column names you would be interested in having added to the CSV file for published updates and what details from the update would be most helpful? (e.g. update classification, title, severity, URL, etc.)

    • Casey O'Rourke
      Reply
      |       Sep 17, 2019

      Thanks, Justin. A couple of us here will be looking forward to that.

    • Admin
      Justin Chalfant
      Reply
      |       Sep 17, 2019

      I'm hoping we will have the CSV option sometime next month maybe later this month. We haven't started any coding it though, but I don't think it will be a problem.

    • Casey O'Rourke
      Reply
      |       Sep 11, 2019

      Thanks, Justin. It didn't seem difficult. Ideally being able to create and then append the same CSV so I can point scripts to a static location. I don't think that would be too difficult?

      Also, I've been already looking at the raw RSS feed data to formulate the best method of parsing that data with PowerShell. Doesn't seem too difficult. Just a matter of finding time to do it. :-D

    • Admin
      Justin Chalfant
      Reply
      |       Sep 11, 2019

      I think we could do a CSV creation. You could maybe use our RSS feed in the meantime? https://patchmypc.com/category/scupcatalogupdates/feed