sn_vul_vulnerable_item

chetansriram
Kilo Expert

‎07-12-2023 08:56 AM - edited ‎07-12-2023 09:07 AM

what are the possible values for sysparm_query for the vulnerable_item table. I am looking for all the VIT's for a particular configuration item. I tried cmdb_ci.name=linuxsrv15 but it yields empty output.  There are 170 VIT's for this asset. 

 

Please see both the attachments

 

Please help

@Johns_MP 

Preview file
24 KB
Preview file
12 KB
0 Helpfuls
  • 1,129 Views
1 REPLY 1

Bert_c1
Kilo Patron

‎07-14-2023 06:49 AM

Hi,

 

The 'sn_vul_vulnerable_item' table has a reference field name 'cmdb_ci'. Reference fields contain the 'sys_id' value of the record in the referenced table. You post partial information, hard to tell what to recommend here.

 

See screenshot from a list view of records for one specific CI

 

Screenshot 2023-07-14 094745.png

 

The query is: 

 

cmdb_ci=1c49454d8f6fa300a3c953ac37bdee8b