Need a report with active, disable services and open port for all device

[leblanc_daniel_]

Hello all,

Need a big help, need a report with active, disable services and open port for all device.

Thank you for you re help.

Dan

[Daniel_B · Accepted solution]

The following report lists services scanned on computers in your network. You need to have scanning of services enabled under Configuration\Item Wait Time.
Data about Firewall configuration is not being scanned.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tblServicesUni.Name As Service,
  tblServiceStartMode.StartMode,
  tblServicesUni.Pathname,
  tblServicesUni.Startname
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
  Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
    tblServices.StartID
  Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
    tblServices.ServiceuniqueID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  Service