Add Last Logon or last status message

[KeithDib]

Hi

I need to add last logon date or last status message to the existing report 'Hardware 01A' report to see how long since a machine was used [sort of]

i have exported and imported it to create a duplicate to work on, but do not know to add this extra data and field.

simple to a lot of you I'm guessing, not to me

 

cheers

[GarthMJ]

So the last status message might not be helpful. As if no one login to the computer but it is turned on.  You will still get status messages from it. as from when someone last logon. you can get this information from v_GS_SYSTEM_CONSOLE_USER sql view.