Our master list is based on who is in what group on the CiscoSecure ACS appliances, because this is the real level of access users have. An audit script runs against that and updates the table I am hitting. So the only way for me to identify current users is to check the upate_timestamp field. As long as my script runs after the other auditing script then the string comparison is fine. And if they do not match up then my script will exit (well, I will probably have it email me a warning that there were no users found).

With that said, it would probably make more sense to find any entries that update_timestamp is 24 hours old or less in instead of doing the string comparison. And this was supposed to be a quick and dirty script.

Regarding hostile: The 'Because you can't just make stuff up?" paragraph. The "question" sets a pretty negative tone, and the rest of the paragraph reinforces it. It didn't help that it felt like you glossed over my post -- i.e. that the query works in SQL Developer. I mean, it worked, so I wasn't just "making stuff up".

Elda Taluta; Sarks Sark; Ark Arks

In reply to Re^6: DBIx::Simple and Oracle dates (stuff) by Argel
in thread DBIx::Simple and Oracle dates by Argel

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.