cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

AppStack Relationship Report

AppStack.png

Labels (1)
Attachments
Comments

Rad

One slight problem with the query.  You have

....

Node.VirtualMachine.Host.DataStores.DisplayName AS DataStore,

Node.VirtualMachine.Host.DataStores.LUNS.DisplayName as LUN,

Node.VirtualMachine.Host.DataStores.LUNS.Pools.DisplayName AS Pool,

Node.VirtualMachine.Host.DataStores.Luns.StorageArray.DisplayName As StorageArray

....

This references ALL of the datastores on the host.  However, you only want the datastores that are related to the virtual machine.  Therefore that should read:

...

Node.VirtualMachine.DataStores.DisplayName AS DataStore,

Node.VirtualMachine.DataStores.LUNS.DisplayName as LUN,

Node.VirtualMachine.DataStores.LUNS.Pools.DisplayName AS Pool,

Node.VirtualMachine.DataStores.Luns.StorageArray.DisplayName As StorageArray

...

Also, I added the pool in that query.

Report updated. Thanks animelov‌!

How would I change this to pull specific applications?

When I run this in my environment I am getting every application possible?

Lastly, I found I am getting a cleaner report when I replaced UNION with UNION ALL.

How would I change this to pull specific applications?

Best way to do this is to add to the where clause:
Where Node.VirtualMachine.NodeID IS NOT NULL AND Node.Applications.DisplayName = (name of application)

Don't forget to also do this for the physical servers in the second half of the query

When I run this in my environment I am getting every application possible?

Technically yes, technically no.  The report is keyed off of all Nodes in the database, so, the official answer is no, because it is showing you all nodes.  But applications have to be assigned to a node, so, all applications would show since all Nodes will show.  So, technically yes.

Lastly, I found I am getting a cleaner report when I replaced UNION with UNION ALL

Ok .  Care to paste an example please?

Ok so I stand corrected on the Union ALL.  This was due to my resolution.

Sorry to keep asking questions, I have been trying reading through all of this to come up to speed. (this is what happens when you stick a virtualization person into a new role)

So i can pull all the Node.XXXXX properties.  How can i start pulling other properties like Serial numbers or such?  Is there a list of all variables possible and not just node properties?

Also, how can i control from which I am pulling, in other words, host or vm on the host?

Hi,

sorry to keep pestering about this.

I was going through this script, trying to make some changes as per requirements.  So looking through the DB it self to find the appropriate field I am not able to match any of the field from above to the DB, yet in my report I am able to pull the data.


The database I am looking through is SWindsNPM

I requested the DB Schema and guide from SW support but was told that they do not release that information.

.

Version history
Revision #:
1 of 1
Last update:
‎05-13-2015 09:27 PM
Updated by: