• State Verified Answer
  • Replies 2 replies
  • Subscribers 32 subscribers
  • Views 3096 views
  • Users 0 members are here
Options
Related

Need field added to custom report provided by Quest.

michael good
over 4 years ago

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

Parents
  • 0 over 4 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

Reply
  • 0 over 4 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

Children