This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Topics in this forum

Sign in/Join

User not seen in X days

Hi folks,hope someone can help.Is there, or can someone help with a report that would list AD users who have not logged on in a specific range - say 30 days?My SQL knowledge is pretty poor, so I don't know where to start in writing one myself.Thanks!...

Microsoft security advisory 4025685 report help

Hi all,I've been attempting to create a report that checks for assets that are missing a number of patches. This is to help report on the latest Microsoft advisory 4025685 that lists a number of patches for different OS. With the help of some repor...

dabravokid by • Engaged Sweeper
  • 9397 Views
  • 5 replies
  • 0 kudos

Tickets Over 30 Days old

Replace 'lansweeperurl' with your server for success.Select Top 1000000 'http://lansweeperurl/Ticket.aspx?tid=' + Cast(htblticket.ticketid As varchar) As hyperlink_Subject, htblticket.subject As hyperlink_name_Subject, htblticket.date As [Date Ope...

Resolved! Out of Date Software Report by Machine Name?

Hi kind of a newb with LS so here goes my question: is there a way to build a report that displays all the out of date installed software by machine name? Hope my question makes sense and thanks in advance

Adding ADUsers First name Last Name to a report

Our users log in using an employee number. In AD this employee number is tied to their First Name Last Name. I am trying to add user to a custom report. When i add username it gives me their employee number. When i add TblADUser to the report my ...

Report to list all installed and active services

Hello,Can't find this in the forum and existing reports, neither in the assets detail.I need to provide the list of installed and active windows services, could you help?I can only find the reports for stopped services, so I believe it should be poss...

Phil1960 by • Engaged Sweeper
  • 6729 Views
  • 1 replies
  • 0 kudos

Resolved! Find computers with duplicate Office entries on tblSerialNumber

Hi all,Due to some mishap (still being investigated) during a Microsoft Office upgrade, we ended up with several machines with duplicate Office entries on the Software->License Keys table, we have the old version entry and the new version there, for ...

fjca by • Champion Sweeper II
  • 7615 Views
  • 3 replies
  • 0 kudos

Resolved! Users that logon locally

Is it possible to generate a report of computers and/or users that are logging in locally instead of the domain?I recently found that some of the computers have local computer accounts on them and I suspect that some of the users might be logging on ...

ejensen by • Engaged Sweeper III
  • 12504 Views
  • 5 replies
  • 0 kudos
li.common.scroll-to.top