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...
i want to create a report which includes, Computer name,logged in User, processor, RAM, Hard Disk (total Size & free Size partition wise),IP Address,Serial number. How can i create this report.?
I would like to create a report of assets that don't have certain sofware installed.I have already created following report with the parameter Not Like 'Pulse Secure Installer Service' , but this will create a list of every software packet on each co...
For the life of me I cant figure out why the report builder won't output the ticketID in my report. It will work and run the report and show my other fields, however, it won't output the ticketID which is an important piece of data as well as the fi...
