→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cdonizetti
Engaged Sweeper III
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
0 REPLIES 0