Skip to Main Content
Patch My PC Feature and Application Request

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

0 VOTE
Status SHIPPED
Created by Casey O'Rourke
Created on Sep 10, 2019

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
  • 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. :-)

  • 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?

  • 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