Last Logon details(Date and time) from SCCM Integration

[Pranita2]

Hi,

We have implemented SCCM integration and is working fine.

Client needs user's Last Login details such as Date and Time from SCCM Integration.

I have created a field called "Last Login Date" and trying to map with SCCM field "Last_Logon".

But even after mapping i am getting error as invalid column name.

I have attached the mapping and error screenshots. Can anyone help me with proper column name or which other field can be mapped to get the desired output.

Many thanks,

Pranita

[Ashutosh Munot1]

Hi,

Use Join query in your SQL query. You SCCM database developer can give you that query.

Thanks,
Ashutosh

[rajat11]

How do we map them with CMDB ,Any suggestion .I am not able to understand flow between different SCCM tables