SCCM Integration- Last logged in details

[Pranita2]

Hi,

We have implemented SCCM Integration in our instance.

Requirement we have is to get the last logged in details from SCCM to Servicenow instance

How can i achieve this?

Thanks,

Pranita

[Arvind Singh Ra]

Hi Pranita,

I would use SCCM mappings:

1)   Create a new field on the Computer table for "Last Logged On User" - map the username mapping (currently in the OOB SCCM)

2)   Create a new field on the Computer table for "Identified Primary User" - map the top console user value (v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0)

3)   OPTIONAL - Comment out the OOB mapping for Assigned_to - let your asset management processes set this

Mark ✅ Correct and 👍 Helpful based on the impact.

Warm Regards,

Arvind

[Pranita2]

Hi Arvind,

As we are mapping user_name to Assigned_to field, is there any other way to populate "Last Logged On User" field.

Also i am not able to find v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0 in the SCCM mappings.

Thanks,

Pranita