VCenter - What VM's have ISOS mounted? | Product Discussions

VCenter - What VM's have ISOS mounted?

With https://kb.vmware.com/s/article/87249 announced the other day, it seemed like a perfect use-case for LM since we use it to monitor all our vcenter instances, but I don't see anything specific to ISOS & VCenter VM's. Apologies in advance if I have overlooked the obvious.

clinton_buss

Posted 4 years ago·Last reply 4 years ago

10 comments

LM User

·4 years ago

Would be good to bundle a TopoSource with this so that VMs can be mapped to ISOs.

clinton_buss

OP4 years ago

@Michael Baker and @Michael Rodrigues - you guys are great! Asked a question and just a few hours later had a script and it was even in the vetted Exchange list - Thanks!

Michael Baker

·4 years ago

2 minutes ago, Michael Rodrigues said:

@Michael Baker you will need to toggle it to "Public" in the "My Repository" tab of the Exchange for others to download it.

We default everything to "Private" to avoid accidental publish.

Done!

Michael Rodrigues

·4 years ago

@Michael Baker you will need to toggle it to "Public" in the "My Repository" tab of the Exchange for others to download it.

We default everything to "Private" to avoid accidental publish.

Michael Rodrigues

·4 years ago

Great! It's passed Security Review.

Michael Baker

·4 years ago

Done G3Y49X

Michael Baker

·4 years ago

Just now, Michael Rodrigues said:

Awesome turnaround @Michael Baker. If you publish that to the Exchange I can put it through Security Review for you.

Minor bigfix then I will push we have sooo many VC's doing it by hand would be nasty

Michael Rodrigues

·4 years ago

Awesome turnaround @Michael Baker. If you publish that to the Exchange I can put it through Security Review for you.

Michael Baker

·4 years ago

Round 2 this is much faster:

<span class="pun"><?</span><span class="pln">xml version</span><span class="pun">=</span><span class="str">"1.0"</span><span class="pln"> encoding</span><span class="pun">=</span><span class="str">"UTF-8"</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="tag"><feed</span><span class="pln">  </span><span class="atn">version</span><span class="pun">=</span><span class="atv">"1.0"</span><span class="pln"> </span><span class="atn">hasPendingRequests</span><span class="pun">=</span><span class="atv">"false"</span><span class="pln"> </span><span class="tag">></span><span class="pln">
  </span><span class="tag"><company></company></span><span class="pln">
  </span><span class="tag"><status></span><span class="pln">200</span><span class="tag"></status></span><span class="pln">
  </span><span class="tag"><errmsg></span><span class="pln">OK</span><span class="tag"></errmsg></span><span class="pln">
  </span><span class="tag"><interval></span><span class="pln">0</span><span class="tag"></interval></span><span class="pln">
    </span><span class="tag"><entry</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"predatasource"</span><span class="tag">></span><span class="pln">
        </span><span class="tag"><version></span><span class="pln">1641510208</span><span class="tag"></version></span><span class="pln">
        </span><span class="tag"><name></span><span class="pln">VMware_vCenter_Check_If_ISO_Mounted</span><span class="tag"></name></span><span class="pln">
        </span><span class="tag"><displayedas></span><span class="pln">VMWAre VM Check If ISO Mounted</span><span class="tag"></displayedas></span><span class="pln">
        </span><span class="tag"><description></span><span class="pln">Detect possible CVE</span><span class="tag"></description></span><span class="pln">
        </span><span class="tag"><collector></span><span class="pln">batchscript</span><span class="tag"></collector></span><span class="pln">
        </span><span class="tag"><hasMultiInstances></span><span class="pln">true</span><span class="tag"></hasMultiInstances></span><span class="pln">
        </span><span class="tag"><useWildValueAsUniqueIdentifier></span><span class="pln">false</span><span class="tag"></useWildValueAsUniqueIdentifier></span><span class="pln">
        </span><span class="tag"><schedule></span><span class="pln">120</span><span class="tag"></schedule></span><span class="pln">
        </span><span class="tag"><appliesTo></span><span class="pln">system.virtualization =~ &#34;VMware ESX vcenter&#34;</span><span class="tag"></appliesTo></span><span class="pln">
        </span><span class="tag"><wildcardauto></span><span class="pln">true</span><span class="tag"></wildcardauto></span><span class="pln">
        </span><span class="tag"><wildcardpersist></span><span class="pln">false</span><span class="tag"></wildcardpersist></span><span class="pln">
        </span><span class="tag"><wildcardlinuxscript></span><span class="pln">ad_script</span><span class="tag"></wildcardlinuxscript></span><span class="pln">
        </span><span class="tag"><wildcardlinuxcmdline></span><span class="pln">type=&#34;embeded&#34; </span><span class="tag"></wildcardlinuxcmdline></span><span class="pln">
        </span><span class="tag"><wildcardwinscript></span><span class="pln">ad_script</span><span class="tag"></wildcardwinscript></span><span class="pln">
        </span><span class="tag"><wildcardwincmdline></span><span class="pln">type=&#34;embeded&#34; </span><span class="tag"></wildcardwincmdline></span><span class="pln">
        </span><span class="tag"><wildcardgroovyscript></span><span class="pln">/*******************************************************************************
 * © 2007-2019 - LogicMonitor, Inc. All rights reserved.
 ******************************************************************************/

import com.vmware.vim25.*;
import com.vmware.vim25.mo.*;
import java.security.cert.*;
import org.apache.http.auth.*;
import org.apache.http.conn.ssl.*;
import org.apache.http.impl.client.*;
import org.apache.http.util.EntityUtils;
import org.apache.http.client.methods.HttpGet;
import com.santaba.agent.groovyapi.esx.ESX
import groovy.json.JsonSlurper;

def host = hostProps.get(&#34;system.hostname&#34;)
def user = hostProps.get(&#34;esx.user&#34;);
def pass = hostProps.get(&#34;esx.pass&#34;);
def addr = hostProps.get(&#34;esx.url&#34;) ?: &#34;https://${host}/sdk&#34;;
def keyNamespace = hostProps.get(hostProps.get(&#34;topo.namespace&#34;, &#34;&#34;), &#34;&#34;)
def keyBlacklist = hostProps.get(&#34;topo.blacklist&#34;, &#34;&#34;).tokenize(&#34;,&#34;)

// Open a connection to the vSphere API, get a service instance and root folder

def svc = new ESX();
svc.open(addr, user, pass, 10 * 1000); // timeout in 10 seconds

def si = svc.getServiceInstance();
def rootFolder = si.getRootFolder();

// Get VMs
def vms = new InventoryNavigator(rootFolder).searchManagedEntities(&#34;VirtualMachine&#34;);

// Get ESX Hosts
def hostsystems = new InventoryNavigator(rootFolder).searchManagedEntities(&#34;HostSystem&#34;)

// iterate over vms
vms.each { vm -&#62;

    // Get AD info
    def wildvalue = vm.MOR.val;
    def wildalias = vm.name;
    def config = vm.config.hardware.device
        for(dev in config)
        {
            if(dev instanceof com.vmware.vim25.VirtualCdrom) {
                if(dev.backing instanceof com.vmware.vim25.VirtualCdromIsoBackingInfo) {
                    if(dev.connectable.connected) {
                        println &#34;${wildvalue}##${wildalias}&#34;;
                    }
                }
            }
        }
}

return 0
</span><span class="tag"></wildcardgroovyscript></span><span class="pln">
        </span><span class="tag"><wildcardschedule></span><span class="pln">60</span><span class="tag"></wildcardschedule></span><span class="pln">
        </span><span class="tag"><wildcarddisable></span><span class="pln">false</span><span class="tag"></wildcarddisable></span><span class="pln">
        </span><span class="tag"><wildcarddeleteinactive></span><span class="pln">false</span><span class="tag"></wildcarddeleteinactive></span><span class="pln">
        </span><span class="tag"><agdmethod></span><span class="pln">none</span><span class="tag"></agdmethod></span><span class="pln">
        </span><span class="tag"><agdparams></agdparams></span><span class="pln">
        </span><span class="tag"><group></group></span><span class="pln">
        </span><span class="tag"><tags></span><span class="pln">application,vsphere,virtualization,vm,vmware</span><span class="tag"></tags></span><span class="pln">
        </span><span class="tag"><technology></span><span class="pln">:: replaces old ESX_VM_Status ::
- define esx.user and esx.pass for authentication
- optionally override vSphere API URL with esx.url property
- optionally enable vSphere Tags -&#62; instance level properties by setting esx.tags to &#34;true&#34; (vCenter only)
- url-encode ILPs that are strings in AD script</span><span class="tag"></technology></span><span class="pln">
        </span><span class="tag"><adlist></span><span class="pln"><![CDATA[{"agdmethod":"none","method":"ad_script","agdparams":"","id":0,"filters":[],"params":{"type":"embeded","groovyscript":"/*******************************************************************************\n * © 2007-2019 - LogicMonitor, Inc. All rights reserved.\n ******************************************************************************/\n\nimport com.vmware.vim25.*;\nimport com.vmware.vim25.mo.*;\nimport java.security.cert.*;\nimport org.apache.http.auth.*;\nimport org.apache.http.conn.ssl.*;\nimport org.apache.http.impl.client.*;\nimport org.apache.http.util.EntityUtils;\nimport org.apache.http.client.methods.HttpGet;\nimport com.santaba.agent.groovyapi.esx.ESX\nimport groovy.json.JsonSlurper;\n\ndef host = hostProps.get(\"system.hostname\")\ndef user = hostProps.get(\"esx.user\");\ndef pass = hostProps.get(\"esx.pass\");\ndef addr = hostProps.get(\"esx.url\") ?: \"https://${host}/sdk\";\ndef keyNamespace = hostProps.get(hostProps.get(\"topo.namespace\", \"\"), \"\")\ndef keyBlacklist = hostProps.get(\"topo.blacklist\", \"\").tokenize(\",\")\n\n// Open a connection to the vSphere API, get a service instance and root folder\n\ndef svc = new ESX();\nsvc.open(addr, user, pass, 10 * 1000); // timeout in 10 seconds\n\ndef si = svc.getServiceInstance();\ndef rootFolder = si.getRootFolder();\n\n// Get VMs\ndef vms = new InventoryNavigator(rootFolder).searchManagedEntities(\"VirtualMachine\");\n\n// Get ESX Hosts\ndef hostsystems = new InventoryNavigator(rootFolder).searchManagedEntities(\"HostSystem\")\n\n// iterate over vms\nvms.each { vm ->\n\n    // Get AD info\n    def wildvalue = vm.MOR.val;\n    def wildalias = vm.name;\n    def config = vm.config.hardware.device\n        for(dev in config)\n        {\n            if(dev instanceof com.vmware.vim25.VirtualCdrom) {\n                if(dev.backing instanceof com.vmware.vim25.VirtualCdromIsoBackingInfo) {\n                    if(dev.connectable.connected) {\n                        println \"${wildvalue}##${wildalias}\";\n                    }\n                }\n            }\n        }\n}\n\nreturn 0\n"}}]]></span><span class="tag"></adlist></span><span class="pln">
        </span><span class="tag"><schemaVersion></span><span class="pln">2</span><span class="tag"></schemaVersion></span><span class="pln">
        </span><span class="tag"><dataSourceType></span><span class="pln">1</span><span class="tag"></dataSourceType></span><span class="pln">
        </span><span class="tag"><attributes></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">scripttype</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></span><span class="pln">embed</span><span class="tag"></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">scriptgroovy</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></span><span class="pln">import com.vmware.vim25.mo.*;
import com.santaba.agent.groovyapi.esx.ESX;

def host = hostProps.get(&#34;system.hostname&#34;)
def user = hostProps.get(&#34;esx.user&#34;);
def pass = hostProps.get(&#34;esx.pass&#34;);
def addr = hostProps.get(&#34;esx.url&#34;) ?: &#34;https://${host}/sdk&#34;;

def svc = new ESX();
svc.open(addr, user, pass, 10 * 1000); // timeout in 10 seconds

def si = svc.getServiceInstance();
def rootFolder = si.getRootFolder();

def vms = new InventoryNavigator(rootFolder).searchManagedEntities(&#34;VirtualMachine&#34;);


vms.each
{
    vm -&#62;
        def wildvalue = vm.MOR.val;
        def config = vm.config.hardware.device
        for(dev in config)
        {
          if(dev instanceof com.vmware.vim25.VirtualCdrom) {
            if(dev.backing instanceof com.vmware.vim25.VirtualCdromIsoBackingInfo) {
              if(dev.connectable.connected) {
                 println &#34;${wildvalue}.isoconnected=1&#34;;
              }
            }
          }
        }       
        
}

return 0;</span><span class="tag"></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">windowsscript</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">linuxscript</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">windowscmdline</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">linuxcmdline</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">eridetectioninterval</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></span><span class="pln">60</span><span class="tag"></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">eriscripttype</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></span><span class="pln">embeded</span><span class="tag"></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">eriscriptgroovy</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></span><span class="pln">import com.santaba.agent.util.esx.EsxVcService
import com.vmware.vim25.VirtualDisk
import com.vmware.vim25.mo.Folder
import com.vmware.vim25.mo.InventoryNavigator
import com.vmware.vim25.mo.ManagedEntity
import com.vmware.vim25.VirtualEthernetCard
import com.vmware.vim25.VirtualDevice
import groovy.json.JsonSlurper
import org.apache.http.auth.AuthScope
import org.apache.http.auth.UsernamePasswordCredentials
import org.apache.http.client.methods.HttpGet
import org.apache.http.conn.ssl.AllowAllHostnameVerifier
import org.apache.http.conn.ssl.SSLContexts
import org.apache.http.conn.ssl.TrustStrategy
import org.apache.http.impl.client.BasicCredentialsProvider
import org.apache.http.impl.client.HttpClients
import org.apache.http.impl.client.LaxRedirectStrategy
import org.apache.http.util.EntityUtils
import java.security.cert.CertificateException
import java.security.cert.X509Certificate
def host = hostProps.get(&#34;system.hostname&#34;)
def user = hostProps.get(&#34;esx.user&#34;);
def pass = hostProps.get(&#34;esx.pass&#34;);
def custom_url = hostProps.get(&#34;esx.url&#34;);
def vmMorVal = instanceProps.get(&#34;wildvalue&#34;);
def vmName = instanceProps.get(&#34;wildalias&#34;);
def eri = host+&#34;--&#34;+vmMorVal;
def ExternalResourceIDs = [eri]
// Open a connection to the vSphere API, get a service instance and root folder
def url = custom_url ?: String.format(&#34;https://%s/sdk&#34;, host);
def svc = EsxVcService.connect(url, user, pass, 10 * 1000); // timeout in 10 seconds
def si = svc.getServiceInstance();
def rootFolder = si.getRootFolder();
ManagedEntity[] vms;
// Get VMs
vms = new InventoryNavigator(rootFolder).searchManagedEntities(&#34;VirtualMachine&#34;);
// iterate over vms
vms.each
{ vm -&#62;
    // Get AD info
    def aVMMorVal = vm.MOR.val
    def aVMName = vm.name
    if(aVMMorVal == vmMorVal) {
        for (VirtualDevice vd : vm.getConfig().getHardware().getDevice()) {
            try {
                if (vd instanceof VirtualEthernetCard) {
                    VirtualEthernetCard vEth = (VirtualEthernetCard) vd;
                    ExternalResourceIDs += vEth.macAddress;
                }
            } catch (Exception e) {
            }
        }
    }
}
println &#34;predef.externalResourceID=&#34; + ExternalResourceIDs.join(&#34;,&#34;);
println &#34;predef.externalResourceType=&#34; + &#34;VirtualMachine&#34;
return 0;</span><span class="tag"></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">eriwinscript</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">erilinuxscript</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">eriwincmdline</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"><attribute></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">erilinuxcmdline</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><value></value></span><span class="pln">
            </span><span class="tag"><comment></comment></span><span class="pln">
        </span><span class="tag"></attribute></span><span class="pln">
        </span><span class="tag"></attributes></span><span class="pln">
        </span><span class="tag"><datapoints></span><span class="pln">
        </span><span class="tag"><datapoint></span><span class="pln">
            </span><span class="tag"><name></span><span class="pln">isoconnected</span><span class="tag"></name></span><span class="pln">
            </span><span class="tag"><dataType></span><span class="pln">7</span><span class="tag"></dataType></span><span class="pln">
            </span><span class="tag"><type></span><span class="pln">2</span><span class="tag"></type></span><span class="pln">
            </span><span class="tag"><postprocessormethod></span><span class="pln">namevalue</span><span class="tag"></postprocessormethod></span><span class="pln">
            </span><span class="tag"><postprocessorparam></span><span class="pln">isconnected</span><span class="tag"></postprocessorparam></span><span class="pln">
            </span><span class="tag"><usevalue></span><span class="pln">output</span><span class="tag"></usevalue></span><span class="pln">
            </span><span class="tag"><alertexpr></alertexpr></span><span class="pln">
            </span><span class="tag"><alertmissing></span><span class="pln">1</span><span class="tag"></alertmissing></span><span class="pln">
            </span><span class="tag"><alertsubject></alertsubject></span><span class="pln">
            </span><span class="tag"><alertbody></alertbody></span><span class="pln">
            </span><span class="tag"><enableanomalyalertsuppression></enableanomalyalertsuppression></span><span class="pln">
            </span><span class="tag"><adadvsettingenabled></span><span class="pln">false</span><span class="tag"></adadvsettingenabled></span><span class="pln">
            </span><span class="tag"><warnadadvsetting></warnadadvsetting></span><span class="pln">
            </span><span class="tag"><erroradadvsetting></erroradadvsetting></span><span class="pln">
            </span><span class="tag"><criticaladadvsetting></criticaladadvsetting></span><span class="pln">
            </span><span class="tag"><description></description></span><span class="pln">
            </span><span class="tag"><maxvalue></span><span class="pln">1</span><span class="tag"></maxvalue></span><span class="pln">
            </span><span class="tag"><minvalue></span><span class="pln">0</span><span class="tag"></minvalue></span><span class="pln">
            </span><span class="tag"><userparam1></userparam1></span><span class="pln">
            </span><span class="tag"><userparam2></userparam2></span><span class="pln">
            </span><span class="tag"><userparam3></userparam3></span><span class="pln">
            </span><span class="tag"><iscomposite></span><span class="pln">false</span><span class="tag"></iscomposite></span><span class="pln">
            </span><span class="tag"><rpn></rpn></span><span class="pln">
            </span><span class="tag"><alertTransitionIval></span><span class="pln">0</span><span class="tag"></alertTransitionIval></span><span class="pln">
            </span><span class="tag"><alertClearTransitionIval></span><span class="pln">0</span><span class="tag"></alertClearTransitionIval></span><span class="pln">
        </span><span class="tag"></datapoint></span><span class="pln">
        </span><span class="tag"></datapoints></span><span class="pln">
        </span><span class="tag"><graphs></span><span class="pln">
        </span><span class="tag"></graphs></span><span class="pln">
        </span><span class="tag"><overviewgraphs></span><span class="pln">
        </span><span class="tag"></overviewgraphs></span><span class="pln">
        </span><span class="tag"><scripts></span><span class="pln">
        </span><span class="tag"></scripts></span><span class="pln">
    </span><span class="tag"></entry></span><span class="pln">
</span><span class="tag"></feed></span>

Mike Moniz

·4 years ago

You would likely need to write a custom DataSource but sounds doable. Perhaps clone VMware_vCenter_VMStatus and modify the groovy code to query mounted media and connected state. You can also try asking LM support if they have anything unofficial or tips.

1	SUYASH GAIKWAD
2	PK Peter Kamuiru
3	SA Sławomir Abrich Align Technology, Inc.
4	SL sunbik lukab
5	JG Joshua Gedeon
6	TK Tammy Kennedy