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
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Sign in/Join

USB Devices Connected to Computers

Hi guys,Is there a report that shows me what USB devices are connected to a computer with the exception of Mice and Keyboards. I want to see USB pens, drives and Mobile Phones that are connected? ThanksDavid

wilkie1984 by • Engaged Sweeper II
  • 7021 Views
  • 3 replies
  • 0 kudos

Resolved! How do I get Date From DateTime?

Unable to figure this out. I've tried using the SQL Server Compact documentation, but I can't figure out which one to use and functions like CONVERT(date, <datecolumn) through date = unknown data type.

laurin1 by • Engaged Sweeper III
  • 6094 Views
  • 2 replies
  • 0 kudos

Resolved! Report based on Asset Groups

Hi all,i gave the best i can do but now im stuck and i dont get the Report to work HALP! What i want:create a Report for all Assets that looks if the Asset is in more than one Asset Group, if it has 2 or more Asset groups assigned dont show it. So s...

konstapel by • Engaged Sweeper
  • 7748 Views
  • 1 replies
  • 0 kudos

Regular Expression Substring

Hello,I'd like to make a report that pulls out a substring of the FTP header. My current report pulls tblAssetCustom.FTPheader but I'd like to get a version number out of it. The version number doesn't always appear at the same index for each asset...

ngebhar2 by • Engaged Sweeper II
  • 5965 Views
  • 1 replies
  • 0 kudos

Users in AD with no assets associated

HiLooking for tips on how to create a report of active users in AD, possibly by OU, that have no computer associated with their account.For a variety of reasons, we have some machines that are not in the LS database, and corresponding users who have ...

Resolved! Remove duplicate

Hi there ! I've seen on some other post people asking for help on removing duplicate. I tried to replicate some of the answer given but I'm not really good with these queries. Can someone help me remove duplicate from this report either by assetname ...

tboisver by • Engaged Sweeper
  • 8431 Views
  • 1 replies
  • 1 kudos