List of profiles from cmd line?

rob133 · Post by **rob133** » Tue Jul 26, 2005 12:07 pm

Hi, what's the best way to get a list of all existing webinator profiles from the command line? RH Linux. I'm planning to refresh all of my profiles from my own cron script instead of the built-in scheduler, and I would like to be able to automatically get a list of all profiles to run through rather than having to add each profile name to my script by hand.

My best guess at this point is to just get a list of directories in INSTALLDIR/texis, excluding "script"... but that doesn't seem reliable to me (there could be other non-profile dirs in there??)

What do you suggest?

Thanks very much,
Rob

Post by **mark** » Tue Jul 26, 2005 1:14 pm

Assuming standard unix installation path:

/usr/local/morph3/bin/texis -d /usr/local/morph3/texis/testdb -s "select Profile from options where Name='SS_dataspace'"

rob133 · Post by **rob133** » Tue Jul 26, 2005 4:36 pm

Perfect, thanks!

rob133 · Post by **rob133** » Tue Jul 26, 2005 5:30 pm

oops, one more thing: what sql would I use to pull the "last complete walk" time for a given profile? (I thought it was SYSSCHEDULE, but that's only if I'm using the internal scheduler, which I'm not).

Thanks

rob133 · Post by **rob133** » Tue Jul 26, 2005 5:37 pm

Sorry to bother, I figured it out.

select Profile,String from options where Name='SSc_walked'