Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

sn_vul_vulnerable_item

chetansriram
Kilo Expert

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

@johnsmp 

1 REPLY 1

Bert_c1
Kilo Patron

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