Please provide your feedback in this short Flings' survey.
May 12, 2021

Hello VSAM team
Thank you for te really useful tool.
I wonder if it's possible to export the collected data to CSV or similar format?
Currently I'm using the --v option during collection and pipe the output to a text file.
It works but it takes a lot of extra steps. We need to import the data into spreadsheets.

TIA
Michael

May 13, 2021

Thank you Michael! This is a good suggestion. We will consider to add this to next vSAM update release. Potential issues with CSV format data is: 1) part of the information might be lost. With the output of '--v', you can see that currently data is collected in JSON format, and it's quite rich. With CSV format, we have to drop some data field and only keep those 'key' information. 2) When the vSAM tool generates reports or merge data files, it checks for duplicates and linked mode vCenters, so as to avoid duplicate counting. If you do the merge or report generation with the generated csv data files, you also need to this kind of checks to make sure the your final report is accurate. If you have suggestions on key data fields that should appear in the CSV data file, feel free to let us know via vsam-feedback@vmware.com.

May 13, 2021

Hello Frank
Thanks for the reply.
Great that you're considering to add CSV as an export option.
I understand that CSV is not as rich as JSON.
Currently I didn't find a way to export the JSON from an existing .vam result file.
In an editor ist shows only junk (maybe because it's encrypted?)
The 'analyze' command does not have a verbose output option.
What is the best way to extract information from a result file (besides PDF)?

TIA
Michael

May 13, 2021

Hi Michael,

Yes, the .vam file is encrypted for security reason. So far there is no way to extract information from this file directly. We will consider to add the export function to vSAM for both json and csv format output.

Thanks,
Frank

Mar 08, 2021

Recevied an error saying cert not trusted, and was prompted to say yes/no to trust the cert, I said yes, then it failed saying it couldn't Now all i get is the error shown below

c:\temp\vsam_1.3>vsam collect

Using the default target file: targets.csv

Validating the target with provided credentials : ContosoHealthcarevCenter--192.168.8.2
Login password not detected in the target file : ContosoHealthcarevCenter
Please input the target login password :
Failed to validate the target: ContosoHealthcarevCenter

Mar 08, 2021

please dis-regard, in the logs says I'm using an account which does not have sufficient privilege ... sorry for the spam.

Mar 08, 2021

No problem. Thanks for using this software. If you need help on this software, feel free to contact us through vsam-feedback@vmware.com.

Sep 15, 2020

Can someone give me the syntax for connecting to a vcenter? I was still confused about the instructions.

Sep 16, 2020

The logic is like this: put your vCenter access information in this file 'targets.csv', then run command 'vsam collect'. This command get the vCenter access information from that file and connect to the vCenter through vSphere API to retrieve data from the vCenter. Feel free to contact us through vsam-feedback@vmware.com.

Jun 25, 2020

[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveLookupServiceAddressInfo] Retrieving LookupService info from vCenter
[2020-06-25 18:07:23 INFO com.vmware.vlat.ssl.VlatTrustManager checkServerTrusted] User confirms to trust remote server, installing its certs to vlat keystore
[2020-06-25 18:07:23 INFO com.vmware.vlat.ssl.KeyStoreManager initVlatKeyStore] Initializing vlat keystore file with C:\Users\balaji071\Desktop\vsam_1.2\conf\.vsamcacerts
[2020-06-25 18:07:23 INFO com.vmware.vlat.VcManager close] Disconnected from vCenter <vcenter name>
[2020-06-25 18:07:23 SEVERE com.vmware.licenseenforcement.DataCollectorImpl collectData] Error occurs when operating vCenter <vcenter name>
com.sun.xml.internal.ws.client.ClientTransportException: HTTP transport error: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at com.sun.xml.internal.ws.transport.http.client.HttpClientTransport.getOutput(Unknown Source)

[2020-06-25 18:07:23 WARNING com.vmware.licenseenforcement.DataCollectorImpl collectData] No data populated from vCenter <vcentername>
[2020-06-25 18:07:23 SEVERE com.vmware.assetmanagement.utils.AssessmentUtil extract] Cannot parse the JSON String
Unexpected token END OF FILE at position 0.

Jun 28, 2020

Salaji, can you send me the complete log files, this will be useful for troubleshooting.

Jul 01, 2020

[2020-06-25 18:00:59 INFO com.vmware.assetmanagement.AssessmentApplication main] current locale is: en_US
[2020-06-25 18:00:59 INFO com.vmware.assetmanagement.AssessmentApplication main] Check and prepare the directory of results
[2020-06-25 18:00:59 INFO com.vmware.assetmanagement.AssessmentApplication main] Check and prepare the directory of profiles
[2020-06-25 18:00:59 INFO com.vmware.assetmanagement.AssessmentApplication main] Application is In Console Mode
[2020-06-25 18:01:23 INFO com.vmware.assetmanagement.AssessmentApplication main] current locale is: en_US
[2020-06-25 18:01:23 INFO com.vmware.assetmanagement.AssessmentApplication main] Check and prepare the directory of results
[2020-06-25 18:01:23 INFO com.vmware.assetmanagement.AssessmentApplication main] Check and prepare the directory of profiles
[2020-06-25 18:01:23 INFO com.vmware.assetmanagement.AssessmentApplication main] Application is In Console Mode
[2020-06-25 18:01:25 INFO com.vmware.assetmanagement.BatchShellRunner runInit] Init Password for the first time usage of the application.
[2020-06-25 18:05:56 INFO com.vmware.assetmanagement.AssessmentApplication main] current locale is: en_US
[2020-06-25 18:05:56 INFO com.vmware.assetmanagement.AssessmentApplication main] Check and prepare the directory of results
[2020-06-25 18:05:56 INFO com.vmware.assetmanagement.AssessmentApplication main] Check and prepare the directory of profiles
[2020-06-25 18:05:56 INFO com.vmware.assetmanagement.AssessmentApplication main] Application is In Console Mode
[2020-06-25 18:05:58 INFO com.vmware.vlat.ssl.KeyStoreManager createVlatCertsFile] Creating empty vlat keystore at C:\Users\balaji071\Desktop\vsam_1.2\conf\.vsamcacerts
[2020-06-25 18:05:59 INFO com.vmware.licenseenforcement.DataCollectorImpl <init>] Using default passphrase to setup vlat keystore
[2020-06-25 18:05:59 INFO com.vmware.assetmanagement.BatchShellRunner runCollector] Choose the default targets file: targets.csv
[2020-06-25 18:05:59 INFO com.vmware.assetmanagement.impl.AssessmentImpl loadTargetsFromFile] Loading targets config from the file: C:\Users\balaji071\Desktop\vsam_1.2\targets.csv
[2020-06-25 18:05:59 INFO com.vmware.assetmanagement.impl.AssessmentImpl loadTargetsFromFile] Current Project Name is: targets
[2020-06-25 18:05:59 INFO com.vmware.licenseenforcement.DataCollectorImpl validate] Validating <vCenter Name>
[2020-06-25 18:05:59 INFO com.vmware.vlat.validator.Validators validate] Validating vCenter <vCenter Name>
[2020-06-25 18:05:59 INFO com.vmware.vlat.VcManager <init>] Connecting to vCenter <vCenter Name>
[2020-06-25 18:06:37 INFO com.vmware.vlat.ssl.VlatTrustManager checkServerTrusted] User confirms to trust remote server, installing its certs to vlat keystore
[2020-06-25 18:06:37 INFO com.vmware.vlat.ssl.KeyStoreManager initVlatKeyStore] Initializing vlat keystore file with C:\Users\balaji071\Desktop\vsam_1.2\conf\.vsamcacerts
[2020-06-25 18:06:38 INFO com.vmware.vlat.VcManager <init>] vCenter <vCenter Name> is connected. Name:VMware vCenter Server 6.5.0 build-7119157, ApiVersion:6.5, Uuid:99e53a0e-27ac-4b06-8b53-e310e2692d28
[2020-06-25 18:06:38 INFO com.vmware.vlat.VcManager retrieveAboutInfo] Retrieving basic info from vCenter
[2020-06-25 18:06:38 INFO com.vmware.vlat.VcManager close] Disconnected from vCenter <vCenter Name>
[2020-06-25 18:06:38 INFO com.vmware.vlat.validator.VcConnectionValidator validate] Supported vCenter version: [5.5, 8). Current version is 6.5.0
[2020-06-25 18:06:38 INFO com.vmware.vlat.validator.Validators validate] vCenter <vCenter Name> passed validation: true
[2020-06-25 18:06:38 INFO com.vmware.assetmanagement.impl.AssessmentImpl validateTarget] The target is validated successfully : TestvCenter
[2020-06-25 18:06:38 INFO com.vmware.assetmanagement.impl.AssessmentImpl collectAllData] The data is collecting in the target : TestvCenter
[2020-06-25 18:06:38 INFO com.vmware.licenseenforcement.DataCollectorImpl collectData] Collecting data from <vCenter Name>
[2020-06-25 18:06:38 INFO com.vmware.vlat.VcManager <init>] Connecting to vCenter <vCenter Name>
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager <init>] vCenter <vCenter Name> is connected. Name:VMware vCenter Server 6.5.0 build-7119157, ApiVersion:6.5, Uuid:99e53a0e-27ac-4b06-8b53-e310e2692d28
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveAboutInfo] Retrieving basic info from vCenter
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveLicenseInfo] Retrieving license info from vCenter
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveLicenseInfo] 5 licenses retrieved from vCenter
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveLicenseInfo] 8 license assignment retrieved from vCenter
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveHostInfo] Retrieving host info from vCenter
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveHostInfo] 6 hosts retrieved from vCenter
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveAboutInfo] Retrieving basic info from vCenter
[2020-06-25 18:06:50 INFO com.vmware.vlat.VcManager retrieveLookupServiceAddressInfo] Retrieving LookupService info from vCenter
[2020-06-25 18:07:23 INFO com.vmware.vlat.ssl.VlatTrustManager checkServerTrusted] User confirms to trust remote server, installing its certs to vlat keystore
[2020-06-25 18:07:23 INFO com.vmware.vlat.ssl.KeyStoreManager initVlatKeyStore] Initializing vlat keystore file with C:\Users\balaji071\Desktop\vsam_1.2\conf\.vsamcacerts
[2020-06-25 18:07:23 INFO com.vmware.vlat.VcManager close] Disconnected from vCenter <vCenter Name>
[2020-06-25 18:07:23 SEVERE com.vmware.licenseenforcement.DataCollectorImpl collectData] Error occurs when operating vCenter <vCenter Name>
com.sun.xml.internal.ws.client.ClientTransportException: HTTP transport error: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at com.sun.xml.internal.ws.transport.http.client.HttpClientTransport.getOutput(Unknown Source)
at com.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.process(Unknown Source)
at com.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.processRequest(Unknown Source)
at com.sun.xml.internal.ws.transport.DeferredTransportPipe.processRequest(Unknown Source)
at com.sun.xml.internal.ws.api.pipe.Fiber.__doRun(Unknown Source)
at com.sun.xml.internal.ws.api.pipe.Fiber._doRun(Unknown Source)
at com.sun.xml.internal.ws.api.pipe.Fiber.doRun(Unknown Source)
at com.sun.xml.internal.ws.api.pipe.Fiber.runSync(Unknown Source)
at com.sun.xml.internal.ws.client.Stub.process(Unknown Source)
at com.sun.xml.internal.ws.client.sei.SEIStub.doProcess(Unknown Source)
at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.invoke(Unknown Source)
at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.invoke(Unknown Source)
at com.sun.xml.internal.ws.client.sei.SEIStub.invoke(Unknown Source)
at com.sun.proxy.$Proxy48.retrieveServiceContent(Unknown Source)
at com.vmware.vlat.LookupService.<init>(LookupService.java:72)
at com.vmware.vlat.VlatData.getLinkedVcenters(VlatData.java:81)
at com.vmware.vlat.VlatData.toMap(VlatData.java:56)
at com.vmware.licenseenforcement.DataCollectorImpl.collectData(DataCollectorImpl.java:64)
at com.vmware.assetmanagement.impl.AssessmentImpl.collectData(AssessmentImpl.java:194)
at com.vmware.assetmanagement.impl.AssessmentImpl.collectAllData(AssessmentImpl.java:179)
at com.vmware.assetmanagement.utils.AssessmentUtil.collectData(AssessmentUtil.java:228)
at com.vmware.assetmanagement.BatchShellRunner.runCollector(BatchShellRunner.java:232)
at com.vmware.assetmanagement.BatchShellRunner.run(BatchShellRunner.java:36)
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:804)
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:794)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:324)
at com.vmware.assetmanagement.AssessmentApplication.main(AssessmentApplication.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
... 35 more
Caused by: java.io.EOFException: SSL peer shut down incorrectly
at sun.security.ssl.InputRecord.read(Unknown Source)
... 44 more

[2020-06-25 18:07:23 WARNING com.vmware.licenseenforcement.DataCollectorImpl collectData] No data populated from vCenter <vCenter Name>
[2020-06-25 18:07:23 SEVERE com.vmware.assetmanagement.utils.AssessmentUtil extract] Cannot parse the JSON String
Unexpected token END OF FILE at position 0.
at org.json.simple.parser.JSONParser.parse(JSONParser.java:257)
at org.json.simple.parser.JSONParser.parse(JSONParser.java:92)
at com.vmware.assetmanagement.utils.AssessmentUtil.extract(AssessmentUtil.java:183)
at com.vmware.assetmanagement.utils.AssessmentUtil.collectData(AssessmentUtil.java:237)
at com.vmware.assetmanagement.BatchShellRunner.runCollector(BatchShellRunner.java:232)
at com.vmware.assetmanagement.BatchShellRunner.run(BatchShellRunner.java:36)
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:804)
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:794)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:324)
at com.vmware.assetmanagement.AssessmentApplication.main(AssessmentApplication.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)

Jun 25, 2020

I am gettting above error during vsam collect.
Could some one help me here please?

Jul 02, 2020

I received your email about complete logs, from logs I saw the vc got connected and license data got populated, while the error happened when it tried to retrieved linked vc info. I am not able to reproduce this error in my env so I am wondering it is env caused, can you check your env again to make sure there is no such problem as I said in a former reply (JCE installed for Oracle JDK 8)?

Jun 29, 2020

Let's check your jdk version first, if it is oracle jdk7 or jdk 8 you should install the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files.

Jun 29, 2020

Hi Balaji, thanks for using this software. If this problem still exists, please send the log file to vsam-feedback@vmware.com, so that Junfeng and other developers can debug this issues.

Jul 01, 2020

Hi Frank, thanks for response. I am sharing them.