(imported topic written by reema91)
Hi, Can anyone suggest if BigFix can track Oracle or Websphere applications installed on Windows or any other platform - through BigFix license tracking. Thanks
(imported comment written by rkc91)
Here what I have used for oracle
Oracle Database Installed
exists services
whose
(
service name of it as lowercase contains “oracleservice”
)
exists services whose (service name of it as lowercase contains “oracleservice”)
Oracle SID
if
exists
(
service name
whose
(
it as lowercase contains “oracleservice”
)
of services
)
then
(
following texts of firsts “OracleService” of service names
whose
(
it as lowercase contains “oracleservice”
)
of services as lowercase
)
else
“n/a”
if exists (service name whose (it as lowercase contains “oracleservice”) of services) then (following texts of firsts “OracleService” of service names whose (it as lowercase contains “oracleservice”) of services as lowercase) else “n/a”
Oracle Home
if
exists
(
key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry
)
then
(
if
exists
(
value
whose
(
name of it as lowercase = “oracle_home”
)
of keys of key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry
)
then
(
values
whose
(
name of it as lowercase = “oracle_home”
)
of keys of key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry as string
)
else
“n/a”
)
else
“n/a”
if exists (key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry) then (if exists (value whose (name of it as lowercase = “oracle_home”) of keys of key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry) then (values whose (name of it as lowercase = “oracle_home”) of keys of key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry as string) else “n/a”) else “n/a”
Oracle Server Version
if
(
exists
(
services
whose
(
service name of it as lowercase contains “oracleservice”
)
)
and
exists
(
key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry
)
)
then
(
unique value of values “FileVersion” of version blocks of files
(
preceding texts of firsts " " of image paths of services
whose
(
service name of it as lowercase contains “oracleservice”
)
)
)
else
“n/a”
if (exists (services whose (service name of it as lowercase contains “oracleservice”)) and exists (key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry)) then (unique value of values “FileVersion” of version blocks of files (preceding texts of firsts " " of image paths of services whose (service name of it as lowercase contains “oracleservice”))) else "n/a"Relevance
exists
(
key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry
)
exists (key “HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE” of registry)
(imported comment written by Tima91)
Hi, I am also looking for relevance that searches for installed middleware like db2 and websphere.
Thanks
Tima