Hi everyone,I'm trying to run a report to show me all of the users that are not in one of the two groups that we use to define our screen lock time. The problem that I'm having is that I can't find a way to filter out all of the groups that aren't re...
Hi, I'm looking to create a report where (if possible) you type the computer name or asset name you're looking for and it will output the Service Tag, Warranty Expiration, and Last Logged On User. If it's possible I'd love to get the OU of the last ...
I need to know if it possible to create a report based on First Seen. What I am looking for is we want all desktops that are older than say 5yrs to come up in the list. I would need the same for Monitors, switches, etc.
I have a report that gives me all occurrences of event logs with disk related errors and which machine that happened on, warranty end date, etc. However, I'm trying to add a couple columns that convert the format the identifier is in the event log to...
Old name: Services: Microsoft cluster service installed (Built-in)The report below lists Windows computers with Microsoft cluster service installed.The report will only list assets that meet all of the following criteria:The computer's state is set t...
Hi,I am not a SQL guru so I need help. My customer has Lansweeper 5.1.0.50. I need to create one query for a hardware file that produces DomainName,DeviceName,OperatingSystem,DeviceType,ServicePack,IPAddress,PhysicalOrVirtual,Computer Make, Model Ser...
I’m trying to do an asset change report showing the recently assigned assets (I put info in custom1..custom6). I store the assignee’s employee number in Custom1; but since that’s not the most descriptive information, I do a left-join on the tblAduser...
