Session relevance to pull property information from an analysis

Reporting
1

Hello,

Sorry I am still learning and having trouble creating a custom HTML report.

Basically, I am trying to print the infromation from an anylsis (Certificates - Windows) specifically form the property “Certificates - Plain Text Certificate Identification”

I have tried to make the relevance but am not having any luck.

Any help would be greatly appreciated.

Thanks,

2

I believe this should work if the name of the property is correct

(names of computers of it, values of it) of results whose (exists values of it) of bes properties whose (name of it = "Certificates - Plain Text Certificate Identification")

1 Like
3

If you haven’t used the Excel connector it’s also an easy way to create the session relevance that you want to use even if you don’t plan to use the excel connector going forward to pull the data.

image
image795×681 26.2 KB

image
image773×667 50.4 KB

Lines 1,2,3, 6 and 7 of the session relevance are used for parsing the report into Excel so you can remove those and clean it up but it’s an easy way to pull in property data from session relevance.
image
image1274×732 51.5 KB

2 Likes
4

Thanks a lot for detailing information. This information is useful for me and other user.

1 Like
5

Thank you so much for your reply: I used your relevance to create what I Needed:

<?Relevance (names of computers of it) of results whose (exists values of it) of bes properties whose (name of it = "Certificates - Plain Text Certificate Identification" and name of source analysis of it = "Certificates - Windows")?> 
        <td><?Relevance (values of it) of results whose (exists values of it) of bes properties whose (name of it = "Certificates - Plain Text Certificate Identification" and name of source analysis of it = "Certificates - Windows")?></td>


        <td><?Relevance (names of computers of it, values of it) of results whose (exists values of it) of bes properties whose (name of it = "Certificates - Expiration - Issuing CA" and name of source analysis of it = "Certificates - Windows")?></td>

However, now I am having an issue where I cannot populate the date that queries from this correclty. It just populates a giant blob of information. Each new line of information is on a new line but i would like it to be more seperated out. Perferably lined up across the three sets of data. Hostname - lined up with their expiring certificate etc. Addtionally, maybe in its own box insdie the row.

Any ideas on how I can achieve this with HTML?

Thanks again!

1 Like
6

which site is the Certificates - Windows analysis in? is this a custom analysis?