Search <book_title>...

APTARE IT Analytics System Administrator Guide

Last Published: 2022-09-01

Product(s): APTARE IT Analytics (10.6)

Introduction
1. APTARE IT Analytics Overview
2. Purpose of this document
Preparing for updates
1. About upgrades and updates
2. Determine the data collector version
3. Data collector updates with an aptare.jar file
4. Manual download of the aptare.jar file
5. Portal updates
Backing up and restoring data
1. Best practices for disaster recovery
2. Oracle database backups
3. File system backups
4. Oracle database: Cold backup
5. Oracle database: Export backups
6. Scheduling the oracle database export
7. Oracle database: On demand backup
8. Restoring the APTARE IT Analytics system
9. Import the oracle database
10. Manual steps for database import / export using data pump
Monitoring APTARE IT Analytics
1. Starting and stopping portal server software
2. Starting and stopping the reporting database
3. Starting and stopping data collectors
4. Monitoring tablespaces
Accessing APTARE IT Analytics reports with the REST API
1. Overview
2. Authentication for REST APIs
3. Extracting data from tabular reports (with pagination)
4. Exporting reports
5. Exporting custom dashboards
Defining NetBackup estimated tape capacity
1. NetBackup estimated tape capacity overview
2. Estimated capacity notes
3. Updating the estimated capacity table
4. Listing volume pool IDs and media types
Automating host group management
1. About automating host group management
2. Task overview: managing host groups in bulk
3. Preparing to use PL/SQL utilities
4. General utilities
5. Categorize host operating systems by platform and version
  1. Use Regular Expressions to Override or Modify Default Host OS Categorization
  2. Host OS Categorization Default Settings
  3. Utility to Update Host OS Categorizations
  4. Categorize Host Operating Systems On Demand
6. Identifying a host group ID
7. Move or copy clients
8. Organize clients by attribute
9. Move host group
10. Delete host group
11. Move hosts and remove host groups
12. Organize clients into groups by backup server
13. Merge duplicate backup clients
14. Bulk load utilities
  1. Load host aliases
  2. Load details of new hosts or update existing hosts
  3. Load relationships between hosts and host group
    1. Sample Audit File (output from load_package.loadGroupMemberFile)
15. Veritas NetBackup utilities
16. Automate NetBackup utilities
  1. Scheduling a NetBackup Utility Job to Run Automatically
17. Organize clients into groups by management server
18. Set up an inactive clients group
19. Set up a host group for clients in inactive policies
20. Set up clients by policy
21. Set up clients by policy type
22. IBM Tivoli storage manager utilities
23. Set up clients by policy domain
24. Set up clients by IBM Tivoli storage manager instance
25. Scheduling utilities to run automatically
  1. Sample .sql file (setup_ora_job.sql) to set up an automatic job
Attribute management
1. Attribute bulk load utilities
2. Attribute naming rules
3. Rename attributes before upgrading
4. Load host attributes and values
5. Load attributes and values and assign to hosts
6. Load array attributes and values and assign to arrays
7. Overview of application attributes and values
8. Load application database attributes and values
9. Load MS Exchange organization attributes and values
10. Load LUN attributes and values
11. Load switch attributes and values
Importing generic backup data
1. About generic backup data collection
  1. Considerations
2. Configuring generic backup data collection
3. CSV Format Specification
  1. EXAMPLE: genericBackupJobs.csv
4. Manually loading the CSV file
Backup job overrides
1. Overview
2. Configure a backup job override
Managing host data collection
1. Identifying hosts by WWN to avoid duplicates
2. Setting a host's priority
3. Determining host ranking
4. Loading host and WWN relationships
5. Loading the host HBA port data
6. Create a CSV file
7. Execute the script
System configuration in the portal
1. System configuration in the portal
2. System configuration: functions
3. Navigation overview
4. System configuration parameter descriptions: Additional info
5. Data collection: Capacity chargeback
6. Database administration: database
7. Host discovery: EMC Avamar
8. Host discovery: Host
9. Custom parameters
10. Adding/editing a custom parameter
11. Portal customizations
12. Configuring global default inventory object selection
13. Restricting user IDs to single sessions
14. Customizing date format in the report scope selector
15. Customizing the maximum number of lines for exported reports
16. Customizing the total label display in tabular reports
17. Customizing the host management page size
18. Customizing the path and directory for File Analytics database
19. Configuring badge expiration
20. Configuring the maximum cache size in memory
21. Configuring the cache time for reports
Performance profile schedule customization
1. Overview
2. Customize the performance profile schedule
Configuring AD/LDAP
1. About user authentication
2. AD/LDAP Configuration Properties
3. AD/LDAP Configuration for authentication and authorization
4. Support LDAP over SSL
  1. Sample portal.properties configurations for AD/LDAP
5. Creating portal super users
6. Active directory tools
7. Using LDP to find the base DN
8. Using LDP to search active directory
Configuring single sign-on (SSO) using security assertion markup language (SAML)
1. Overview
2. Single sign-on (SSO) prerequisites
3. Setting up the external Identity Provider (IDP) server
  1. Users and groups in the external LDAP directory
  2. Registering with the IDP server
4. Activating single Sign-on (SSO) in the portal
5. SSO troubleshooting and maintenance
Change Oracle database user passwords
1. Overview
2. Database connection properties
3. Modify the Oracle database user passwords
4. Configure Oracle passwords in system configuration files
5. Determine if Oracle is using the default login password
Integrate with CyberArk
1. Introduction
2. CyberArk setup prerequisites
3. Setting up the portal to integrate with CyberArk
Tuning APTARE IT Analytics
1. Before you begin tuning
2. Tuning the portal database
3. Performance recommendations
4. Reclaiming free space from Oracle
5. Portal / Data receiver Java memory settings
Working with log files
1. About debugging APTARE IT Analytics
2. Turn on debugging
3. Database logging
4. Portal and data collector log files - reduce logging
  1. Portal Log Files
  2. Data Collector Log Files
5. Database SCON logging - reduce logging
6. Refreshing the database SCON log
7. Logging user activity in audit.log
8. Logging only what a user deletes
9. Logging all user activity
10. Data collector log files
11. Data collector log file organization
12. Data collector log file naming conventions
13. General data collector log files
14. Find the event / meta collector ID
15. Portal log files
  1. Managing Apache Log Files
16. Database log files
17. Installation / Upgrade log files
Defining report metrics
1. Changing backup success percentage
2. Changing job status
SNMP trap alerting
1. Overview
2. SNMP configurations
3. Standard OIDs
4. Data in an alerting trap
SSL certificate configuration
1. SSL certificate configuration
2. SSL implementation overview
3. Obtain an SSL certificate
4. Update the web server configuration to enable SSL
5. Configure virtual hosts for portal and / or data collection SSL
6. Enable / Disable SSL for a Data Collector
7. Enable / Disable SSL for emailed reports
8. Test and troubleshoot SSL configurations
9. Create a self-signed SSL certificate
10. Configure the Data Collector to trust the certificate
11. Keystore file locations on the Data Collector server
12. Import a certificate into the Data Collector Java keystore
13. Keystore on the portal server
14. Add a virtual interface to a Linux server
15. Add a virtual / secondary IP address on Windows
Portal properties: Format and portal customizations
1. Introduction
2. Configuring global default inventory object selection
3. Restricting user IDs to single sessions
4. Customizing date format in the report scope selector
5. Customizing the maximum number of lines for exported reports
6. Customizing the total label display in tabular reports
7. Customizing the host management page size
8. Customizing the path and directory for file analytics database
9. Configuring badge expiration
10. Configuring the maximum cache size in memory
11. Configuring the cache time for reports
12. Configuring LDAP to use active directory (AD) for user group privileges
Advanced configuration for NetBackup discovery
1. Discovery module overview
2. Activate a Discovery license
3. Modify Discovery system parameters
4. About SNMP probes
5. Why enable SNMP?
6. Enabling SNMP for Windows (NT/2000/XP)
7. Enabling SNMP for Red Hat Linux
8. Enabling SNMP for HP-UX
9. Example--Installing Net-SNMP
10. Troubleshooting Net-SNMP installations
Data retention periods for SDK database objects
1. Data retention periods for SDK database objects
2. Find the domain ID and database table names
3. Retention period update for SDK user-defined objects example
4. SDK user-defined database objects
5. Capacity: default retention for basic database tables
6. Capacity: default retention for EMC Symmetrix enhanced performance
7. Capacity: Default retention for EMC XtremIO
8. Capacity: Default retention for Dell EMC Elastic Cloud Storage (ECS)
9. Capacity: Default retention for Windows file server
10. Capacity: Default retention for Pure Storage FlashArray
11. Cloud: Default retention for Amazon Web Services (AWS)
12. Cloud: Default retention for Microsoft Azure
13. Cloud: Default retention for OpenStack Ceilometer
14. Configure multi-tenancy data purging retention periods
Troubleshooting
1. Troubleshooting user login problems
2. Forgotten password procedure
3. Login issues
4. Connectivity issues
5. Data Collector and database issues

AD/LDAP Configuration Properties

AD/LDAP configuration supports following properties and can be set in the in portal.properties file.

OS specific portal.properties file location:

Linux: /opt/aptare/portalconf/portal.properties
Windows: C:\opt\aptare\portalconf\portal.properties

Table: AD/LDAP Configuration Properties

Property	Description
ldap.enabled	To enable LDAP, set this property to true. Supported Values: true \| false
ldap.searchBase	Location from where the search will be performed to locate users in the authentication directory. Often referred to as the Active Directory (AD) Search Base, this is the starting point in the Active Directory tree for searching for LDAP users. This search base, in LDAP distinguished name format, contains a fully qualified domain name. APTARE IT Analytics supports only one Search Base. Example: dc=example,dc=company,dc=com
ldap.url	Set to the host and port of your AD. Note that this URL value has a prefix ldap:. If using SSL, change the prefix to ldaps. If you are using Active Directory for your external LDAP configuration, you may want to use the global catalog port of 3268 instead of port 389. If using SSL, you may want to use the secure global catalog port of 3269 or 636 for standard LDAPs. Example : ldap://example.company.com:389 OR ldaps://example.company.com:636
ldap.dn	Set to the ID of a user who has permission to search the SEARCHBASE. This user must be able to search all LDAP directory servers. APTARE IT Analytics requires a user that has privileges to search under the Base DN (Distinguished Name) within the Active Directory structure. This must be an account that has administrative privileges, typically an Administrator. It can be the Administrator account that was created when Active Directory was installed, or it can be an account that was created, and either was given administrative privileges or was placed into a group with administrative privileges. If you use Active Directory, specify this setting because Active Directory services do not allow anonymous binds. Microsoft Active Directory requires the username and password of a user that has enough privileges to search the LDAP directory. Example: ldap.dn =CN=Admin,CN=Users,DC=example, DC=company,DC=com
ldap.password	Set to the password of the user who is used in ldap.dn property. It will get empty and encrypted value will be set in `ldap.password.encrypted` property when you restart Portal Tomcat Service after configuring LDAP.
ldap.password.encrypted	It is set when you restart the Portal Tomcat service after configuring LDAP. It has encrypted value of the `ldap.password` property.
ldap.loginAttribute	The login attribute used for authentication. This is the attribute name in Active Directory that specifies the username, such as uid or sAMAccountName. Example: ldap.loginAttribute=sAMAccountName
ldap.authorization	If set to true, Portal authorizes the user against AD groups. At least one AD group of which the new user is member must be configured as a User Group in the Portal. Note: If the AD group is not mapped with the User Group in the Portal, then authentication fails during login with the error: "No user group mapping present for external LDAP user." Supported Values: true \| false
ldap.newUserDomain	Portal domain name where new user gets created. It is only used if `ldap.authorization` is set to true. To find domain name in portal, navigate to Admin > Domains > Domain Name Example: ldap.newUserDomain=example.company.com
ldap.keystore	If SSL support is enabled for LDAP, then it must have: The keystore path location which contains AD certificates The aptare:tomcat permission Note: If SSL is not enabled for LDAP, then this must be commented out.
ldap.keystore.password	Password for the keystore which is set in `ldap.keystore` property. It will get empty and encrypted value will be set in `ldap.keystore.password.encrypted` property when you restart the Portal Tomcat Service after configuring LDAP. Note: If SSL is not enabled for LDAP, then this must be commented out.
ldap.keystore.password.encrypted	It is set when you restart the Portal Tomcat service after configuring LDAP. It has encrypted value of the `ldap.keystore.password` property. Note: If SSL is not enabled for LDAP, then this must be commented out.