→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Richard_A
Engaged Sweeper II
I want to delete the Renamed ITORG\SSW0820\1 to BUFFALO\SSW0820\1 comments that are generated when computers are rename. I have a query, but I do not know how to delete the comments. any help would be great

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Description,
tblAssetComments.Comment
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetComments On tblAssets.AssetID = tblAssetComments.AssetID
Where tblAssetComments.Comment Like N'%Renamed%' And tblAssetCustom.State = 1
Order By tblAssetComments.Comment Desc
0 REPLIES 0