Milan_Volejnik

Usage of business hours is shown at http://thwack.solarwinds.com/ideas/1758.

Hi, it's possible to create your own alert which would inform you that the data collections fail, i.e.: Search Query: "host.perfDate:[* TO now-30minutes]", evaluated on Performance data collections, or Search Query: "host.timestamp:[* TO now-12hours]", evaluated on Configuration data collections.

Usage of business hours in alerts is shown at http://thwack.solarwinds.com/ideas/1758.

Hi, there's an option to take business hours into consideration. 1. simpler solution - on Criteria tab, "Base Alert On" pane use this xpath: "hours-from-dateTime(/virtualMachine/perfDate)" - on Criteria tab, "Triggers On" set a time range 2. example of more complex option (setting of working hours 11:20 to 11:40) - on…

Hello, the repository tables were changed as a part of the upgrade, including CON_ALERT_HISTORY. I would like to suggest to change the query used for Custom alert. For example, for the query related to CON_ALERT_HISTORY it can be used DB ID directly instead of getting it from the COND using db name.

Hello, you can read this thread to get inspired: https://thwack.solarwinds.com/product-forums/database-performance-analyzer-dpa/f/forum/19312/install-database-performance-analyzer-on-windows-10 You can also run "SolarWindsDPASetup-x64.exe /?" to get full list of available options.

Sorry to mislead you. The reports are created from the console in /data/var/hyper9/data/content/reports folder. Once the Python report is created, you will see it in VMAN under "On-Demand Reporting" menu. I don't know any interface in VMAN for creation of such reports. As it's written in the Admin guide, "Reports are…

There's an option to create your own Python reports (in /data/var/hyper9/data/content/reports folder, reports are available in Reporting - On Demand Reporting menu). I tried to create one but unfortunately no success. Small workaround - if you change 1st line of the script to psql -d hyper9db -U h9pgsu -H -o…

A vApp in vCenter and vApp created manually in VMAN are two different and independent Apps. It's not necessary to create a vApp in vCenter to have the "Add to App" option available. I'd suggest that you contact SolarWinds support.

Hello, I agree with you, this should be documented. Can you inform me if you succeeded / failed with this Label issue? Is anything else I can help?

1. setup IP address(es) that can attach the database: in /var/lib/pgsql/data/pg_hba.conf add this line: host all all xx.yy.zz.0/24 trust where xx.yy.zz.0 is set of IP addresses which will be able to connect the DB, 24 is a subnet mask (adjust it to your needs) 2. enable listening to the addresses: in…

Hello, here's a screenshot of a label created for C:\ datastore of Hyper-V host: As you can see, the label was created and assigned to the datastore. Please keep in mind that it's necessary to run Performance data collection job in order to get the label displayed. If this isn't your case please insert exact steps you did…

Here's one of possible solutions: 1) create a file (rwx permissions for root) containing this script: SQL querypsql -d hyper9db -U h9pgsu -H -o /home/VM_Disk_latency_results_`date +"%Y_%m_%d"`.html -c " select date_trunc('day', a.time_stamp), count(a.guid) as Alert_raised from alert_recs a join workspace_file as w ON…

blackpearl​, good news. A new attribute is gathered from VMware for Virtual machines: vm.osuptime * collected by Performance job * available only when vmware tools installed and enabled * no data for HyperV * not reset by vMotion So if you adjust your alerts to use vm.osuptime, you won't get false positive alerts when…

Hello, did you notice there are more sheets (tabs) in the XLS document?

I almost ran out of my ideas. I'd suggest clearing browser cache or trying to open the page on another browser. If it doesn't help, SolarWinds support should assist you to fix it.

Hello, just a question: are you logged in VMAN as a user or an admin account? The user accounts don't have rights to create manual vApp.

Sorry, I didn't get your last reply. You can set up a trend for more BUs. Can't you get all ASC and CRP servers together in the search module? If it's the case then the query is something like this: vm.name:"ASC*" OR vm.name:CRP*" and you will get all VMs having ASC or CRP in the beginning of their name. If I could…

Yes, you are right. VMAN can't get historical overview in Search module. So only way is to use Time Travel. Or eventually to write a PowerCLI script.

Hi, you can launch the SQL query several ways. The fastest way is to run the query in VMAN console, see examples: psql -d hyper9db -U h9pgsu -c 'SELECT * FROM auth_user' - the command shows results of the command in screen psql -d hyper9db -U h9pgsu -c 'SELECT * FROM auth_user' > users.txt - the command stores results into…

It's really weird. Just some ideas come to my mind: - are the cluster names unique and distinct? - do the cluster names contain special characters (i.e. apostrophes)? - is cluster A name a part of cluster C name?

Chris, historical data is stored in alert_recs table, alert details (i.e. name, owner, etc.) are in workspace_file table. The command may look like this: select date_trunc('day', a.time_stamp), count(a.guid) from alert_recs a JOIN workspace_file as w ON a.alert_guid = cast(w.id as varchar) where w.name = 'VM Disk Latency'…

Hi, if you are unable to login to SSH with "admin" user then it may point to a serious problem. Please contact SolarWinds Support.

The months.to.keep.. property is available from VMAN 6.0. Please upgrade to newest version.

Dmytro, you can find the answer in this Thwack thread (at the bottom). A table that contains users' info is called "auth_user". Let me know if it's helpful.

So try logging via SSH (admin / admin) and: 1) check if tomcat service is running /etc/init.d/tomcat status 2) look at the h9maint.log cat /var/hyper9/logs/h9maint.log If I'm right you can't switch back to latest snapshot, can you? Anyway, I'd suggest that you contact SolarWinds support.

It's not necessary to do anything in vCenter. The "Add to App" button should be available in any case. I'd suggest that you contact SolarWinds Support, send them logs and they will help you. You can also create vApp in vCenter or assign labels to VMs (as mentioned earlier) to be able to aggregate statistics. And then, as…

Sorry for misleading you. The examples were intended to give you a hint focusing on the text in bold. FYI the query mentioned above is copied from "VMs with Bad Tools" alert which is included in every VMAN:

Hi, correct format of the search formula is: vm.name:"Servername*" AND vm.snap.dateCreated:[* TO now-30days] If you want to exclude set of VMs then you can use: vm.snap.dateCreated:[* TO now-30days] AND NOT vm.name:"Servername*" or shorter format: vm.snap.dateCreated:[* TO now-30days] -vm.name:"Servername*"

I'd recommend that you: 1) shutdown the VM 2) go to VM settings, remove old NIC(s) and add the VMXNET 3 adapter 3) start the VM If you have DHCP then the VM should get the IP addr automatically. In case of static IP addr you will probably need to re-configure the settings (appliance - netconfig command). Note: if you have…