Need field added to custom report provided by Quest.

I have a report that I imported from this forum for "Machines not logged in the last N days". I am not able to edit this report and add fields, I'm assuming its because you created temp tables to pull this information. On this report I am trying to link the workstation name to the user account. This may be an easy request because in the computer description field for the computer we have added the user account name. Can I please have the description field added to that report so I can say who's machine it belongs too? Right now the only fields in the CSV Options are DomainName, CanonicalName, ComputerName, and LastLogonTime.

Thank you

0 Philip.Isukuru over 5 years ago

Hi Michael,

if you are willing to edit the report the lines below can be update to include the description or let me know to create a new report.

Lines below can be updated from the query tab when editing the report

change
select TMP.DomainName, TMP.CanonicalName, TMP.ComputerName, TMP.LastLogonTime
to
select TMP.DomainName, TMP.CanonicalName, TMP.ComputerName, TMP.Description, TMP.LastLogonTime

change
select distinct D.DomainName, OU.CanonicalName, C.ComputerName,
to
select distinct D.DomainName, OU.CanonicalName, C.ComputerName, C.Description,

Thanks,
Philip
Cancel
Up 0 Down

Reply

Reject Answer

Cancel
0 michael good over 5 years ago in reply to Philip.Isukuru

Awesome, thank you very much!
Cancel
Up 0 Down

Reply

Verify Answer

Cancel