Has anyone created a ServiceNow report for expired machine, applications?

[ParvanaGasimov]

I need to create a ServiceNow report for expired certifications. Can someone assist with that request? 

Thank you,

Parvana Gasimov

[Tabassum22 · Accepted solution]

Hi @ParvanaGasimov ,

It's not possible with "sys_certificate" table to create a report directly. However, you can create a database view for the same and it will work for you as below

Step 1: Create a Database view 

Step 2: Add you table of "sys_certification" in it.

Step 3: click on "Try it" and check the table is visible 

Step 4: Create a report now you'll be able to see the database view.

Step 5: Add the condition as below 

The above will give you list of Expired certificates.

Please mark it helpful and try to give it a thumbs up if the above helps. Please accept the solution.

Thanks & Regards

Tabassum Sultana