As a CMDB Manager last logged in & primary user

[ARAVINDA11]

TEAM , Please help me how can I achieve below process

As a CMDB Manager, I want/need to track the last logged on user and the identified primary user of the CI based on the discovery tool so that  we have key details related to CIs to better manage the Cis.

add the following fields to the CI form - to gather discovery information related to hardware
 - u_last_logon_user   - the user who was logon during the scan 
 - u_identified_primary_user    - the identified primary user as determined by the discovery tool 

[Rahul Priyadars]

its must be on all env.

It should be like this if u are not seeing take help of service now admin

Regards

RP

[ARAVINDA11]

@Rahul Priyadars 

Any links are there to follow this process please share,

Standard SCCM SG Connector. -> I CAN SEE IN PDI

A JDBC data source to SCCM Database  -> is it SQL QUERY should I have to change it?

fire query to fetch PRIMARY USER Attribute from SCCM -> Please share the steps?

Use a Transform Map to Update the Attribute in Computer CI Class. -> please share how to do?

[Rahul Priyadars]

Hi 

Service Now Developer/Admin Can help you on all below things from ur team. but sharing few more inputs.

A JDBC data source to SCCM Database  -> is it SQL QUERY should I have to change it?

fire query to fetch PRIMARY USER Attribute from SCCM -> Please share the steps?

Use a Transform Map to Update the Attribute in Computer CI Class. -> please share how to do?

JDBC you have to Create it and It will Point to SCCM data base.

SCCM Admin can give the query you just have to Tell Him your requirement.

Service Now Developer can write Transform MAP for you.

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/import-sets/task/cr...

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/integrate/cmdb/reference/h...

Regards

RP