Servicenow - PostgreSQL - pattern extension to read pg_hba.conf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a month ago
Hello, can someone help me inform how I can create a pattern extension for the PostgreSQL database to read its configuration file pg_hba.conf and store it in a CI attribute?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a month ago
@ExtremeDigital There is an out of the box Discovery Pattern for PostgreSQL, click on the 'New' Button of the 'Extension Section'. After that, navigate to this pg_hba file and try to get data you need and add it to CI Attribute. Please find attached screen shot.
If you had never done an extension section configuration, explore this course on Servicenow University, where they explain/train you in detail, on how to get the info related iTunes and append it back to CI Attributes. This course will help you do the current task efficiently.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a month ago
Thank you. I'm already working on an extension but I'm not sure how to create the command to read the pg_hba.conf file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
@ExtremeDigital As part of the Identification Pattern, the config file already discovered, and data is populated. If you want a similar Config file to be discovered, you can follow the steps used in Identification pattern from Step 7 onwards and make similar ones for pg_hba.conf file.
I am not able to exactly help you, because I don't have any Postgre SQL DB to test/connect. You can connect in 'Debug' mode to an example one and explore these steps. Once you get good understanding, you can create similar steps in Extension Part of Pattern.