SQL join columns
Hello! Help to combine the columns in the report. I'm not really friends with SQL) join (CurrentHorizontalResolution CurrentVerticalResolution) to get an EXAMPLE view: 1366x768Thanks!
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
Hello! Help to combine the columns in the report. I'm not really friends with SQL) join (CurrentHorizontalResolution CurrentVerticalResolution) to get an EXAMPLE view: 1366x768Thanks!
I need to create a static group who include all assets belonged to a fixed list of users. For example, a Contoso department of a company has User A, User B, and User C. All of them have a PC (from Lansweeper's viewpoint, an asset). Is there a way to ...
HI Everyone, Can lansweeper use the report output to check whether the computer has hardware or software installed or changed? For example, add 8G of memory today or replace the hard disk, or install PDF Reader software thank you~
I need to add a custom field in report "Active Directory: Enabled/disabled users" where I can manually write a data on each individual user. Is it possible? How can i do it?I want that the data is stored in LanSweeper DatabaseMany thanks.
Hi, Can anyone help clear up the confusion regarding this Chart Widget included in the add-in for the Dashboard and the numbers that its reporting please? I'm not sure of the vertical or horizontal number and where they are coming from. Also, what is...
We have approximately 210+ Dell Latitude 7490 laptops being scanned. I want to create a report to show the Last user: for each of those machines by service tag, so that I can cross reference which of those users have already received updated equipme...
I need to get a list of PCs that don't meet the spec for Windows 11. Has anyone got any ideas on the best way to get this list? We have around 250 PCs most are on W10 22H2 with a few W11, I want to upgrade where possible and replace the ones that wo...
Effectively what I am trying to do is put together a report that shows all of the workstations that have a desktop scanner connected. In particular I want the parent device's Asset Name and the child device's Asset Name on the report filtering the ch...
User | Count |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |