Get an Overview of Your Asset Life Cycle
Managing an IT environment comes with a large variety of tasks. One of those tasks is managing the life cycle of assets in your network. When it comes to the end of the life cycle, knowing which assets to prioritize is key to an efficient asset life cycle. The audit below provides an overview of assets in your environment along with the hardware details and the purchase date retrieved via warranty scanning.
Asset Life Cycle Priority Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssetCustom.PurchaseDate As [Purchase Date], Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.Username, tblAssetCustom.Manufacturer, tblAssetCustom.Model, ProcCapacity.CPU, tblAssets.Memory, tsysIPLocations.IPLocation, tblAssets.Lastseen From tblAssets Inner Join (Select tblAssets.AssetID, Max(Replace(Replace(tblProcessor.Name, '(R)', ''), '(TM)', '')) As CPU From tblAssets Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID Group By tblAssets.AssetID) As ProcCapacity On ProcCapacity.AssetID = tblAssets.AssetID Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Where tblAssetCustom.State = 1 Order By tblAssets.AssetName