→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎01-26-2016 09:11 PM
Solved! Go to Solution.
‎01-30-2016 07:02 PM
Select Distinct Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.OU
From tblADusers
Left Join tblCPlogoninfo On tblCPlogoninfo.Username = tblADusers.Username And
tblCPlogoninfo.Domain = tblADusers.Userdomain
Where (tblCPlogoninfo.AssetID Is Null) Or
(tblCPlogoninfo.AssetID = '')
Order By tblADusers.Userdomain,
tblADusers.Username
‎02-08-2016 02:50 PM
‎02-07-2016 01:23 PM
‎02-05-2016 09:20 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblADusers.Displayname,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblADusers On tblADusers.Username = tblAssets.Username
Where tblAssetCustom.State = 1
‎02-04-2016 02:47 PM
‎02-01-2016 04:50 PM
Select Distinct Top 1000000 tblADusers.Username,
'User Page for: ' + tblADusers.Username As hyperlink_name_hyp,
'http://<main web console URL>/user.aspx?username=' +
Cast(tblADusers.Username As nvarchar) + '&userdomain=XXXXXXX' As hyperlink_hyp,
tblADusers.Description,
tblADusers.whenCreated,
tblADusers.Lastchanged,
tblADusers.OU
From tblADusers
Left Join tblCPlogoninfo On tblCPlogoninfo.Username = tblADusers.Username And
tblCPlogoninfo.Domain = tblADusers.Userdomain
Where (tblCPlogoninfo.AssetID Is Null) Or
(tblCPlogoninfo.AssetID = '')
Order By tblADusers.Username
‎01-30-2016 07:02 PM
Select Distinct Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.OU
From tblADusers
Left Join tblCPlogoninfo On tblCPlogoninfo.Username = tblADusers.Username And
tblCPlogoninfo.Domain = tblADusers.Userdomain
Where (tblCPlogoninfo.AssetID Is Null) Or
(tblCPlogoninfo.AssetID = '')
Order By tblADusers.Userdomain,
tblADusers.Username
‎01-29-2016 09:24 PM
Select Top 1000000 tblADusers.Username,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblADusers.OU
From tblAssets
Right Join tblADusers On tblADusers.Username = tblAssets.Username
Where (tblAssets.AssetID Like '') Or
(tblAssets.AssetID Is Null)
Order By tblADusers.Username,
tblADusers.OU
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now