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

[harishdasari]

Hi Pranita,

You have to check with with SCCM team or database team for the Sql query which will include the correct column name of that database table. Because in their table, field column name might be different, so mapping in service-now will not fix your issue.

Thank you.

[Pranita2]

Hi Harish,

I have column name and table name details, but the concern is how to update the existing sql query as the table is different.

[Ashutosh Munot1]

Hi,

Below is the sample query:

dbo.v_R_System.User_Name0 [Last Logon User Name], dbo.v_R_System.Last_Logon_Timestamp0 [Last logged in time]

Check the proper name in database and query.

Thanks,
Ashutosh

[Pranita2]

Hi Ashutosh,

Thank you for the response.

I have column name and table name details, but the concern is how to update the existing sql query as the table is different.

Thanks,

Pranita