Simulation of FNMS-DataExport to ServiceNOW possible?

steffen1 asked a question.

September 25, 2020 at 12:59 PM

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

FlexNet Manager Suite On-Premises

Top Rated Answers

steffen1
6 years ago
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
Expand Post
- Zip
  sn_FNMS_contract_inventory_preview
  9KB
Selected as Best

All Answers

AamerSharif (Flexera)
6 years ago
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)
Expand Post
- steffen1
  6 years ago
  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
  Expand Post
  - jcaza2 (Flexera Software)
    6 years ago
    
    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? ThanksJames
    Expand Post
    steffen1
    6 years ago
    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
    Expand Post
    steffen1
    6 years ago
    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
    Expand Post
    Zip
    sn_FNMS_contract_inventory_preview
    9KB
    Selected as Best

Related Product Forums

→ Flexera One

→ Snow Atlas

→ FlexNet Manager

→ Snow License Manager

→ App Broker

Need help finding an answer?

Ask a Question →