I don't use SQL too much so I am probably doing this wrong, but what is the correct way to remove strings from a table?In a custom report I have a column that displays the OU the computer is in. I want it to just show the final OU that the computer i...
The report below lists machines that have the Lansweeper Server service installed (i.e. scanning servers) and whose service has connected to your Lansweeper database in the last 7 days. Note that this report may list some non-scanning servers as well...
I am trying to determine how many processor cores are in the CPU of each of our servers in our school district, here is what I have, but it's not displaying any results, any help would be great:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUn...
How would I create a report to show computers using the same network printer. I want to be able to run a report with the printers DNS name or IP address and have it show me all the workstations that are using the printer.Thanks
I have the following query for finding Monitors 'used by' users, but I ran into one hiccup. I also need to be able to see the monitors that don't have the 'used by' relation set as well.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, Con...