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]

U Add these Custom Fields as per your needs in Correct PARENT CI Class.

Attributes you are looking for needs Customization in Pattern.

Let Say Server Class - You need to Customize the Windows & Linux Pattern. 

How - https://developer.servicenow.com/connect.do#!/event/knowledge19/LAB1542/knowledge19_LAB1542_extendin...

Regards

RP

[ARAVINDA11]

@Rahul Priyadars Thanks for your reply this dosent give the solution for my question please answer on below

Can you please help with the below scenario

In cmdb_ci_computer Data are populating through SCCM so I Tried to find any data source  is available as there is no data source available for Service graph connector sccm

my requirement was:

in cmdb_ci_computer I want to have a 2 fields called Last logged on user & Primary user

Please help how can I achive this step using SCCM after creating the field i want to auto populate

[Rahul Priyadars]

So 

Last logged on user---Assigned To Field is populated by SCCM Service Graph Connector OOTB.

Primary user--> For this i would suggest to connect with service now team and build a Small solution on top of Standard SCCM SG Connector. 

A JDBC data source to SCCM Database 

fire query to fetch PRIMARY USER Attribute from SCCM

Use a Transform Map to Update the Attribute in Computer CI Class.

Any customization in Standard SCCM SG connector will make it unsupportable.

Regards

RP 

[ARAVINDA11]

@Rahul Priyadars 

Any links are there to follow this process please share,

Standard SCCM SG Connector. -> where I can find this connector? 

A JDBC data source to SCCM Database  -> is it SQL QUERY?

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?

Also One question I checked SCCM data source I am not able to find computer related source in my DEV instance is it because of that or it will be available in PROD or UAT