- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-27-2025 04:40 AM - edited 03-27-2025 04:41 AM
Hello everyone,
I have a requirement where we have configured service graph connector for Microsoft SCCM to pull data into ServiceNow instance. They have used Robust Import set Transformer where transformer definition type is cmdb integration studio application data source is created and cmdb integration studio entities, entity mapping,entity field mapping, entity engine operation is configured. A scheduled job is created to run this robust import set transformer where transform mapping is done for multiple tables and one of the table is cmdb_sam_sw_install. They have written a business rule on insertion to cmdb_sam_sw_install with condition installed_on.operational_status is one of ceased,under construction then it should abort action(checkbox) is checked.
Due to this everytime during the import thousands of errors are logged. I need to avoid this error in syslog table as it affects the performance of the instance.
Kindly request to suggest a best solution to remove logs from sys log table. Either an alternative solution for business rule or onbefore script in robust import set transformer where the record insertion will be skipped without any error logs in syslog table. As there is no documentation for cmdb integration studio application definition please provide me assistance in resolving this issue.
Thanks in advance!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2025 09:50 PM
There is Conditional script existing for Software Install table
Open the Entity and modify the script as below and the processing time may increase because of checking the status of computer before inserting
Thanks,
Swathi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-28-2025 11:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2025 09:50 PM
There is Conditional script existing for Software Install table
Open the Entity and modify the script as below and the processing time may increase because of checking the status of computer before inserting
Thanks,
Swathi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2025 10:00 PM - edited 03-31-2025 10:02 PM
Hello @SwathiPedireddy ,
Thanks for your response I'll check and update you asap.
In my case it's cmdb_sam_sw_install table where installed_on is a reference field so installed_on.operational_status is a check where installed_on.operational_status is one of ceased or under construction. Can I apply the same logic here for this table ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2025 03:26 AM
Installed on is reference to Computer table that's why here directly checking operational status of computer by querying table with serial number. You can directly test this code.
Thanks,
Swathi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2025 03:28 AM
Hello @SwathiPedireddy,
Thanks for your response I'll test and update you.