There are some duplicate MACs reports but after deep dive into problem I decided to create adapter level report: Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.IPAddress, tblAssets.Mac, lassets.mac ...
Hello Everyone,I am wanting to create a report which lists all computers with a column showing a registry key if it is present.I found the exact report I am looking for in the Lansweeper Report Library but the sample code is missing. The report descr...
Hello,I'd like to make a report of all my Windows PCs and I'd like to have information on the disk containing my c:\ system partition.I've managed to retrieve the information I need, but for the moment I have duplicates for PCs with several disks.Her...
Hello everyone! I have been asked for a report that shows which assets have been removed from inventory and which have bee added new. I've never seen a report as described. Does something like that exist that any of you brilliant people are aware of?
I have created some chart reports.Source of data is https://learn.microsoft.com/en-us/windows/release-health/release-informationChart: Windows 1607 operating systems builds dates Select Top 1000000 Case SubString(tblAssets.oscode, 6, 5) + '.' + t...
Hi Im fairly new to LANSweeper and creating reports and im trying to create a report for only LINUX machines EXCLUDING any ASSETNAMES that have an IP Address for a name. So far i have this, but i cant exclude the IP address's from the name. Im sure i...
LS has a powerful chart. It is Bar-diagram. It can show more than 2 column data.I have developed SQL-query for AD Users. It have to be used with this type chart.You should use report's name with prefix "Chart:".Chart: Status of AD usersQuery: Select ...
I am trying to write a report that will identify all laptops that do not have biometric hardware installed. I was able to find a report that includes all computers with that hardware. Was wondering if this was possible to create?
