Hi I'm trying to create a report based on multiple locations, IP addresses or AD OU's.An example would be 'out of warranty' assets in London, Berlin and Moscow only or All assets without an anti virus installed with IP addresses like 192.168.0.% and ...
Hi, I'm trying to create a report to list all active assets in multiple computer OU's and their child OU's. The code I have so far (below) lists some but not all assets but also doubles up on those assets. Any help greatly appreciated.ThanksSelect To...
Hi I'm after some help if possible, I've been trying to create a report that displays all out of warranty servers based on their vlan, e.gAll ip's in Vlan 10.10.0.* or 10.20.0.*the code I've tried is below, unfortunately it doesn't work, any help...
Hi, I’m trying to add and track the usage of our loan equipment. 1. I stared by creating a new ‘Asset Group’ called ‘Loan Equipment’.2. I then created a new ‘Asset Type’, called ‘Wireless Dongles’.3. I created a new ‘Asset State’ called, ‘On Loan’.4....
I've had to add a large number of assets manually via the "New Asset" option, and have found myself having to type and retype the same details over and over. Instead of having to filter and check you have selected the right assets on the mass edit op...
Sorted it, Here the code for anyone else.Select Top 1000000 tblAssetCustom.AssetID, tblAssets.AssetUnique, tsysOS.OSname, tblAssetCustom.Model, tblAssetCustom.Serialnumber As [Identifying Number], tblAssetCustom.PurchaseDate As [Purchase Date], ...
Thanks the report is now working. also just worked out that the asset states only show, when they have assets assigned. please ignore my last question.Thanks for the help.
Thank you for the reports, unfortunately the second returns an error, "error while getting report Conversion failed when converting the varchar value 'Wireless Dongles' to data type int."Is there a future release or updated planned to show other stat...
Hi, no I wasn't aware I could. I've now tested it and although its a useful feature and would have saved me some time, I think the request for a drop-down box to still be valid, if only to ensure the detail you're entering into the fields is the same...