🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

VOV: Get database column names using vovsql_query

User: "AlanB_22262"
New Altair Community Member
Updated by AlanB_22262

When you run a query against the vovdatabase in NetworkComputer or LicenseMonitor, the results will not contain column names, which are useful for spreadsheets.

To get the column names in a separate query, enter the following, for example:

% source /path-to-rtda/common/etc/vovrc.{csh,sh}  # use the one for your shell type
% vovproject enable licmon
% vovsql_query -rw -e "select column_name from information_schema.columns where table_name='checkouts'"

Comments

No comments on this post.