Hi,
I am wanting to generate a report showing the following, if it all possible...
Computer Name, Department of User, Model of Equipment (Or if PC or Laptop), If they are a member of a specific AD Account, If they have a specific piece of software installed, and lastly the mobile number (Which is on the users AD Account, or blank if non)
I am pretty new to the reports and so far come up with the below ..
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssetCustom.Model,
tblADusers.Department As Department,
tblADusers.Mobile,
tblADGroups.Description,
tblADGroups.Name,
tblAssets.Username
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID,
tblADusers,
tblADGroups
Where tblAssetCustom.State = 1
From this I guess i could be able to filter out the machines i need and specify the group ... Though i am not sure if they are correctly linked up in the report .. Also, the 1000000 results I get back are all from the Lansweeper server, how do i choose not to include this ...
Hopefully someone can shine some light on the request please ? Running V.6022
Many thanks in advance !
