Simulation of FNMS-DataExport to ServiceNOW possible?

[Steffen]

Dear FNMS ServiceNOW Experts,

we dont have physical connection to serviceNOW awailable at the moment - we are early stages; the FNMS-Licensefeature is enabled.

We are using FNMS 2020r1 on prem.

Is there a manual way to trigger the "FULL ServiceNOW export" so that we can verify the data to go out of FNMS and later into ServiceNOW? - or even a select in SQL would be sufficient.

Like a "dry run" if you like.

there are some lowlevel sql queries but i am a kind of stuck here

C:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\DotNet\bin\ServiceNowExport\DataBase\*

Without having the physical connection (user + service now server + token) I could not manage to get any output of FNMS.

Your ideas and hints are much apprechiated - thanks - Steffen

[AamerSharif]

Hey Steffen,

You can try passing connection parameters through the command line to test your connection see if that helps

C:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\DotNet\bin\ServiceNowExport\fnmp_servicenow_export.exe /?

Usage: fnmp_servicenow_export.exe
Required switches:
-user [string] (ServiceNow user id to authenticate connection)
-token [string] (ServiceNow token to authenticate connection)
-url [string] (URL to ServiceNow instance)
-endpoint [string] (ServiceNow endpoint to export data to)
Optional switches:
-connectionTest true (Check connection with ServiceNow)
-withApplications false (Exclude Applications from export)
-withContracts false (Exclude Contracts from export)
-withHardwareInventory false (Exclude HardwareInventory from export)
-changes true (Only send changes since last export)
-changesSince YYYY-MM-DD (Only send changes since date) 
-changesPeriod (Only send changes since number of days in period)

[Steffen]

thanks Aamer for your hint,

unfortunatly I do NOT have any connection (no user, no Token etc...) like i originally described - so I am more looking for some kond of "offline mode" here to generate a ServiceNOW export without any ServiceNOW connection...or at least generate some view onto the data which would be exported if there would be a connection.

greetings

Steffen

[jcaza]

Hello Steffen, 

The ServiceNow_Inventory and ServicNow_Application, are the tables where data is staged.

I don't think it's possible to do an export using the executable, it has required switches (user + service now instance + token).

You could attempt to create the table from above by directly manipulating the SQL script for Inventory.

Uncomment something like the following:

Then Qeury table ServiceNow_Inventory:

SELECT * FROM serviceNow_inventory

@AamerSharif  do you have any further insight into how with no connection to a SNow instance the adapter could pipe to a file or staging tables? 

Thanks

James 

[Steffen]

Thanks James,

that was exactly how far I got before I got s5tuck stuck...the query is runing into errors I dont have them at hand right now

thanks

Steffen

[Steffen · Accepted solution]

I now have managed to adopt the out of the box sql statements and you can simply see the data in sql management stuidio.

- contracts

- inventory

the application sql is currently not in a working mode...

greetings

Steffen