Please use the following report:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%domino%') And
tblComputersystem.Domainrole > 1
To use the report above, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
After you have run the report you can click on Ping Assets and now a column will be added to the report. If the field becomes green then you were able to ping the asset, if it becomes red then Lansweeper is not able to ping the asset. After this you can sort the report on the ping field to see which assets were successfully pinged and which weren't.
