Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-07-2013 07:43 PM
I would like to get this report to pick up the Trend Micro anti-virus software we use. How do I go about editing it so it reports properly? This is the "Default" Workstation: All workstations without Anti-virus software report...Thanks
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID Inner Join tsysantivirus On tblSoftwareUni.softwareName
Like tsysantivirus.Software) And tblComputersystem.Domainrole < 2 And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID Inner Join tsysantivirus On tblSoftwareUni.softwareName
Like tsysantivirus.Software) And tblComputersystem.Domainrole < 2 And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-08-2013 10:21 PM
Please ensure that:
- The anti-virus software package is listed in the Software tab of your computer webpages.
- The anti-virus software package is included in the anti-virus list found under Configuration/Software/Anti-Virus. If it isn't, you can manually add it.
Anti-virus reports work as follows:
- Lansweeper looks at an asset's software records, the records listed in the Software tab.
- Lansweeper compares these records against the anti-virus software list found under Configuration/Software/Anti-Virus.
- If a software package installed on an asset is included in Configuration/Software/Anti-Virus, that asset is deemed to have anti-virus software installed.
- The anti-virus software package is listed in the Software tab of your computer webpages.
- The anti-virus software package is included in the anti-virus list found under Configuration/Software/Anti-Virus. If it isn't, you can manually add it.
Anti-virus reports work as follows:
- Lansweeper looks at an asset's software records, the records listed in the Software tab.
- Lansweeper compares these records against the anti-virus software list found under Configuration/Software/Anti-Virus.
- If a software package installed on an asset is included in Configuration/Software/Anti-Virus, that asset is deemed to have anti-virus software installed.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-08-2013 10:21 PM
Please ensure that:
- The anti-virus software package is listed in the Software tab of your computer webpages.
- The anti-virus software package is included in the anti-virus list found under Configuration/Software/Anti-Virus. If it isn't, you can manually add it.
Anti-virus reports work as follows:
- Lansweeper looks at an asset's software records, the records listed in the Software tab.
- Lansweeper compares these records against the anti-virus software list found under Configuration/Software/Anti-Virus.
- If a software package installed on an asset is included in Configuration/Software/Anti-Virus, that asset is deemed to have anti-virus software installed.
- The anti-virus software package is listed in the Software tab of your computer webpages.
- The anti-virus software package is included in the anti-virus list found under Configuration/Software/Anti-Virus. If it isn't, you can manually add it.
Anti-virus reports work as follows:
- Lansweeper looks at an asset's software records, the records listed in the Software tab.
- Lansweeper compares these records against the anti-virus software list found under Configuration/Software/Anti-Virus.
- If a software package installed on an asset is included in Configuration/Software/Anti-Virus, that asset is deemed to have anti-virus software installed.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-07-2013 09:49 PM
ebrundige wrote:
I would like to get this report to pick up the Trend Micro anti-virus software we use.
Something like this?
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblAssets.Lastseen,
tsysOS.Image As icon,
tblSoftwareUni.SoftwarePublisher,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From
tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tsysantivirus On tblSoftwareUni.softwareName Like tsysantivirus.Software
Order By
tblAssets.AssetName