Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
Here is a report to find computers missing the emergency path from 3/29/2018 - KB4100480.Select Top 1000000 Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblState.Staten...
Good day.I am looking for help with a report that will show what computers have Adobe Acrobat, but not reader. I also need to see the Asset name, software, version, domain, Username, IP address, IP Location, Manufacturer, Model, Adobe Acrobat key.th...
Hi,I'd like to create a report which ONLY lists computers which have a Windows Server OS installed (2003, 2008, 2008 R2, 2012, 2012 R2, 2016 etc), the server name, IP address and the last windows update patch\install date. The order below would be gr...
I am trying to create a report that what computers do have Solarwinds Agent installed. The report runs fine, but it shows duplicate entries for every computer. Here is my code.Select Distinct Top 1000000 tblAssets.AssetID As AssetID1, tblAssets.As...
I am by no means a sql programmer and am looking for help generating a report or two. Our system is seeing many machines posting similar events in the Windows System Log, all having the same event id. I am looking to generate a list of all the mach...
Hello-Was trying to create a report that would show the following, but only for SAN Attached Disk (Not local disk drives):ServerName, Domain, Drive Letter, TotalMB, UsedMB, FreeMB, TypeofSANDisk(tblFloppy.Model)I have a report that I am playing with,...
Hi, I'd like to make a report to list of all assets that meet a certain criteria as selected by this report below:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Username, tblAssets.IPAddress, tblAssets.Memory, tblAssets.Pro...
I saw the VMWARE: Virtual Guest Machines report, and was curious on how I could get the ip address of EACH guest in the report. The ip address in the report is the address of the ESX host.Any idea would be appreciated.
