Hi,
this query help you to find all Oracle Instance in Windows environment.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.NrProcessors,
tsysOS.OSname,
tblServicesUni.Name As IstanceName,
tblServices.Started,
tsysOS.Image As icon
From tblAssets
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServices.ServiceuniqueID =
tblServicesUni.ServiceuniqueID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblServicesUni.Name Like N'OracleService%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
