But at the moment, it goes down the list for 1,12,13,14,2,20,23,24,3,30,34 etcWe wold like it to be sequential, like 1,2,3,10,12,14,19,20,21etc, I hope that makes senseHere is my code.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAss...
This is what I have so far, it lists the last occurrence of event ID 14 when found on a computer. I'm trying to tweak it so it also lists the first time it occurred as well.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Userna...
Anyone, know how to write the report script?Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblBaseBoard.Manufacturer As MBManufacturer, tblUSBController.*From tblAssets Inner Join tblBaseBoard On tblAssets.AssetID = tblBaseBo...
Hi,See below code. Why am I still getting Veeam Backup for Office 365 in my report?Thank you!Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblSoftwareUni.softwareName As software, tblSoftware.softwareVersion As vers...
I have a piece of software that doesn't appear in the add remove programs in Windows. I have set up a file scan for this software and I have a report for it, but I have written a report that show the software on computers that is out of date and I w...
Hi,I'm trying to list all Linux machines the do Not have a particular application installed.I found a similar post on the forum but it seems to return many duplicates.Could someone help please?Thanks
