Getting Database Info

jburke 2019-12-04 19:27:58 UTC #1

Hello,
I am looking to see if BigFix can pull what database type is installed on a server. (SQL, DB2, Oracle)

JonL 2019-12-04 21:33:17 UTC #2

There are probably at least three ways to do that.

Inspect the main binary to determine version.
Inspect DB logs, usually there is version info in them.
Run a SQL to query version and output that to a file. Then scoop up the output in an analysis.

JasonWalker 2019-12-04 23:03:45 UTC #3

Do you have Inventory? Much or all of this should be covered in the default content, you may need to activate a couple of analyses.

JonL 2019-12-05 13:29:25 UTC #4

To Jason’s point, if you have Inventory, it’s probably already in there. For those of us who don’t, we’ve learned to be creative to get the data that we need.

jburke 2019-12-05 13:54:29 UTC #5

Thanks for replying. No I don’t have inventory, our license is Lifecycle. What i was hoping for was an analysis that someone knows of that i can add or activate to get the info i need. I see there are some SQL analysis but i am looking for something that can tell me what database application is installed and i can add that info to a report with other info.