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
Sep 25, 2020 07:59 AM
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
Dec 01, 2020 01:11 AM
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)
Sep 27, 2020 11:10 PM - edited Sep 27, 2020 11:11 PM
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
Sep 28, 2020 01:46 AM
Oct 16, 2020 08:02 AM
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
Oct 19, 2020 08:00 AM