How to execute SQL Command using Pattern for discovery.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2020 01:37 AM
Hello All,
I need to run some SQL command in pattern. So I wanted to know if I can do that directly writing command(for e.g. select * from _v_database) in "Set Command Details" after selecting the "Parse Command Output". Or I need to set applicative credentials for this.
Regards,
Nimmi
- Labels:
-
Discovery
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2020 03:56 AM
If you want to run a specific sql command, you can use sqlcmd. See step 46 "get the edition from sql query if empty" from the sql pattern for inspiration, which runs a sql command.
Another alternative is to use wmi (also see pattern for inspriation)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2020 12:53 AM
Please give the exact name of pattern.
And Netezza is running on Linux based Appliance. So in that case will WMI query work?
Regards,
Nimmi
