/build/static/layout/Breadcrumb_cap_w.png

Where can I access the command line and alternative location information when I query the database?

I'm running a query on the K1000 database to show all software that have a zip file associated with it. I'm looking to get the command line to install the application and the alternative path if there is one. In which table would that information be stored?


0 Comments   [ + ] Show comments

Answers (2)

Posted by: AbhayR 6 years ago
Red Belt
0

All the Software related info is present in ORG*.SOFTWARE table.

Posted by: chucksteel 6 years ago
Red Belt
0

File name is stored in SOFTWARE.FILE_NAME.

Installation command line is in either MI.INSTALL_PARMS or MI.INSTALL_FULL_COMMANDLINE.

Alternate location information is all in the MI table:

MI.ALT_LOCATION

MI.ALT_CHECKSUM


Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ