This reports gives a list of all computers that will be merged if you enable windows rename detection.SELECT '/asset.aspx?assetid=' + Cast(d.y As NVARCHAR(1000)) As [hyperlink_Asset A], y.AssetName As [hyperlink_name_Asset A], y.IpAddress [IP ...
This report shows all windows computer with vPro AMT versionMeets all the following criteria:- Active asset- Windows asset- Intel vPro availableSorted on:- Asset nameSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTyp...
This report shows the items and computers that took the most time to scan.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, TsysWaittime.CFGname,...
This might help: http://www.lansweeper.com/kb/147/clearing-tables-to-free-up-space-and-improve-performance.html3,4:"Truncate logs button"Afterwards: Step 6 to optimize your database
When an object is assigned a GUID, it keeps that value for lifeUntil you reinstall the operating system. The machine is still the same but the GUID is changed