I discovered a report very similar to what I am searching for:http://www.lansweeper.com/Forum/yaf_postst12389_Printer-Inventory.aspx#post44784However, I would like to add a column with the printer's name, as retrieved for the printer asset.My SQL ski...
I would like to be able to make a report on the basis of an AssetGroups Dymanic?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tblAssets.Lasts...
I tried replacing all the tblLinuxSoftware with tblMacOSInfo but keeps giving me an error on the tblsoftwareuniAnyone have Ideas?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon1...
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...
