Want to notify all CE users of downtime. Contact ideas?

[lpjwadsw]

I have the following query to find all CE users in our CE 9 environment:
Select top 2500 SI_NAME
from CI_SYSTEMOBJECTS
where SI_PROGID = 'CrystalEnterprise.USER'
order by si_name

Currently we have around 2300 users. The query runs fine and returns the result set but the format is awful. I was hoping to concatenate this list of users to another TOAD query against our LDAP Master database to find valid email addresses but this is taking me forever because of the format in which the Query Builder returns the list.

Any ideas?

 

[mdwyer]

If you don't get a good answer, here's an ugly one (you did say any ideas): Use the browser's View Source function to create a file with the query results. Load the file into Word (or whatever). Delete everything up to the first user name. Then use search and replace to convert all characters between the end of the name and the record number (2/2300) into TABS. Search/replace everything from "/2300" up to the second user name into a return. This will give you a tab-delimitted list of users and record numbers. (You'll ignore the record numbers, and you might even take a further step to delete them.) For 2300 names, I calculate you'll be dealing with a file of about 1meg.

(Note: Conceptualy, the query result is just an html file. Every user will have a unique name and record number, but everything else - the html - is identical. Remove the fixed characters and you're left with the variable data. But convert the fixed characters to delimiters or you won't be able to read the result.)

 

[lpjwadsw]

Thanks mdwyer for the post. I came to that desperate conclusion to but was hoping for a more elegant solution. I may have to just bite the bullet and do it this way. Thanks again.

 

[mdwyer]

I was going to include a suggestion that you could write a csp script to unload the names and put them in a more usable format. That would be more elegant, but the CE SDK comes with a pretty steep learning curve. If you haven't worked with it, editing the page source from Query Builder would be much easier and quicker.

 

[ShortyA]

A possible solution is to default the CE website to another HTML page which has the current status eg "everything is fine". Set the timeout on this page to 0 when it is up. If there are problems with CE then amend the HTML page to timeout after to 5-10 seconds. The HTML page should be setup to redirect to the normal logon page.

Hope this helps.
ShortyA