Hi,I'm not familiar with SQL queries and I'm needing a few reports for help desk metrics. All reports below are based on our fiscal year (July 1 - June 30).Also, we have an SLA created in the help desk with 2 hour initial response and 1 day for reso...
Hello,i want a report that looks like the summary page of a switch. I need the interface name, alias, vlan and if connected the asset name and also not used interfaces. Like the report from a windows pc.Can someone help me to get this created via sql...
Good Day, I have created the query below to find all members of the Local Administrators group on all Scanned Windows Systems (excluding Domain admins).The issue with this report is that it duplicates all assests and renders the report useless.What a...
I have the following report.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tblAssets.Processor, tblAssets.Memory, tblAssets.IPAddress, tblVideoController.Caption, tblNetworkAdapter.Name, tblIDEController.Captio...
I’m seeing an unexpected behavior in a report. When I add an additional criterion, instead of dropping 1 record like I expect, it drops almost all of them. The report is to show old systems to be replaced, and I want to drop out those I’ve tagged as ...
