For Example server XXXXX01 Total Application hang Number= 4Select Top 1000000 tblAssets.AssetName As AssetName1, tblAssets.Domain, tblAssets.AssetID, tblAssets.Username, tblAssets.Userdomain, tblAssets.Lastseen, tblAssets.Lasttried, tblNtlog.E...
Select Top 1000000 tblAssets.AssetName, tblAssets.Domain, tblAssets.AssetID, tblAssets.Username, tblAssets.Userdomain, tblAssets.Lastseen, tblAssets.Lasttried, case when count.count is null then 0 else count.count end as [Number of ...