Parse the SCM actual configuration data into a report

Question

Hello everyone,

Does anyone tried to parse or have a way to convert the content field data from Orion.SCM.Results.PolledElements ?

My objective is to retrieve the polled data from the Server Configuration profile I created.

This profile it parses all local certificate (using Powershell) from the nodes that have agents in them(Windows server). My next action is to SWQL them and turn them into a report.

Is this possible? or feasible atleast?

In my research the structure or path in Orion.SCM table is

Profile

└─ Element

  └─ Result

    └─ ElementContents

        ├─ Hash ←— checks the change

        └─ Content ←—- result/data but they are in Base64 format

I might be wrong or incomplete with my research as well . Go ahead correct me :)

Any help or idea how is appreciated.

Thank you

Fr0gman · Answer

Honestly thats my first option. However,  SAM is limited to 10 output pairs . Some window servers exceeds 10 local certs. Although majority  we monitor only  have 2-6 certs.

Lofstrand · Answer

If it's certificate information you want to get an output on, why don't try creating a SAM Powershell component. That powershell component can get out the certificate information and that can be parsed into a report or what you want.

Fr0gman · Answer

I am thinking of an alternative way.  From main polling engine or from the Orion SQL DB server, remote access each nodes (via powershell ) parse all local cert > save it in csv > create new table on a separate instance load the content of csv > then SWQL the table from web console (report or dashboard).