Search results for query: *

I have searched the Business Objects knowledge base and found articles detailing steps I have already taken. I already opened a case with BO a while back and am hoping to find the answer more quickly by expanding my audience.

I have just finished installing Business Objects Enterprise XI R2 Premium and when I try to connect to the .NET Admin Launchpad I receive the following error. I have found several articles online that say to grant the Network Service account write access on the referenced folder and I have done...

I have just finished installing BOE XI R2 Premium and when I try to connect to the .NET Admin Launchpad I receive the following error. I have found several articles online that say to grant the Network Service account write access on the referenced folder and I have done that, but that has not...

Thanks for expounding on that. That really helps out for daylight savings time!

Thank you, Bob - that is exactly what I needed.

So there is no way in Crystal Reports 10 to take a date and minus 6 hours?

I really don't have the option to purchase anything. I need a way to do this with the out-of-the-box Crystal Reports designer.

Hello Everyone, I have installed auditing for Crystal Enterprise version 10 and am looking at the sample reports. I have noticed that the TimeStamp field in the CMS_AUDITTABLE table is formatted like this: 2006-03-27(16:41:26:640) This is today's date at 4:41pm. The actual time that this...

I am using the following SQL query (given to me by SQLBill and SQLDennis) to return computer names and a status of each record. SELECT CSD.Name0, SMXLAD.Account00, STATUS = CASE WHEN (SUBSTRING(SMXLAD.Account00, (PATINDEX('%NAME=%', SMXLAD.Account00)+6), (LEN(SMXLAD.Account00)))) NOT IN...

Ok - it is working. I had to put in a quote and change the position to +6 since the account names are surrounded in quotation marks. This works!! Thank you!!!! SELECT CSD.Name0, SMXLAD.Account00, STATUS = CASE WHEN (SUBSTRING(SMXLAD.Account00, (PATINDEX('%NAME=%'...

OK, upon further inspection of the results set, it is not working exactly right. Machine names show up more multiple times and all but 6 machines show to be "Unlocked" which is definitely not the case. Any ideas?

I took out the AS clause and it worked beautifully!!!! Thank you SQLBill and SQLDenis!!!

SQLDenis, I got this error: Server: Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'as'.

Ok, I looked up PATINDEX and found that I needed single quotes around %NAME%, so I changed it to the below query, but now I am getting this error: Server: Msg 156, Level 15, State 1, Line 6 Incorrect syntax near the keyword 'FROM'. SELECT CSD.Name0, STATUS = CASE WHEN...

I forgot to mention that the join should be on the MachineID field. I did test this and I got an error that says: "Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'NAME'." SELECT CSD.Name0, STATUS = CASE WHEN (SUBSTRING(SMXLAD.Account0, (PATINDEX(%NAME=%...

Sure! Here is an example of one computer named WSPAULSA. So this computer has four accounts that are in the administrators group. Only the first three accounts are authorized (desktop, security, admin). So, since this computer has an account other than those three (scott), I would want this...

I need to pull information out of a SQL db using a query. I need to generate a final status of "Locked"or "Unlocked" for each computer in our organization. In order to find out whether the PC is locked down, I have to evaluate what is contained in the SMX_Local_Admins_DATA.Account00 field for...

That was it! It is working! Thank you!!!!

When I launch the CMC, system is the fully qualified domain name of the server. I had just the server name. I will change it and try again.

Just to make sure that I have the CMS name set correctly. When I launch the CMC and look under "Servers", I have input the value that appears under MACHINE NAME. Is that correct? Or should it be machine name.cms?