Search results for query: *

Thanks! The Provider and binding order did the trick AS far as the reg tweak, I've read that deleting the key improves access speed to network shares. Is this what you understand as well? If that's the case then maybe I should try it as well since we've had reports of slow access speeds to our...

We're slowly migrating our network from NDS to AD. We're currently testing a system config where XP is joined to Active Directory. We still use Novell Client for primary authentication and sync the passwords with AD. All is working well but now our network printer searches are taking forever in...

Aftertaf, thx for the reply! The reason we want the OU script to run each time is that we're a bit afraid of policy overlap during our NDS-to-AD migration ... I think we're going to keep ZenWorks but the possibility of policy overlap is a bit high for the time being until we get all this...

Hey all, My shop's migrating from Netware to AD 2003. I want to automate (script) the process of assigning workstation objects to their correct OU in our organization (goes by office first then Computer OU). I have local variables on the image I can call to for office location and such. I've...

UPdate - I logged in with the domain god acct and rolled-back the change ... it looks like it tweaked all the security settings bigtime ... gotta clean it up now. This sucks LOL

ok, what can I do to fix an issue whereby an admin followed the instructions for the Power Users group in the Restricted Group, but applied this to the entire Domain Users group? I can't login to my domain controllers now .. and neither can my domain admininstrator acct. It appears I'm locked...

vbrocks, I'm seeing the same behavior on my Domino server. I had 1GB ram and upgraded to 2GB. The server still shows about 600MB available memory but the Domino services were using almost 4GB (yep 4GB) of memory. The pagefile was being slammed and my page faults counter was almost 1500/sec. I...

excellent Terry! SQL is definitely not one of my strengths as you can tell, but I'm working on it. thanks again for your help -Greg

understood ... what I forgot to mention is that some entries contain only "xx seconds" if that's all the time the user was connected. To catch these I added a CASE statement, and that's probably where it's messing-up. Here's a mock layout I've been working with: 1) --declare string...

thanks Terry. that looks like it's on the right path, however I'm receiving "Error converting data type varchar to numeric." errors from Query Analyzer. I'm trying to determine if the data is some how not returning numeric values now. -Greg

I have an entry in a table for time duration that is formatted as "xxx minutes xx seconds". The application never shows "hours", just "xxx minutes xx seconds" and the minutes can climb as high as it gets (some entries have over 2000 minutes!). Anyways, I'd like to...

Cheyney, that's working SWEEEET! .... thanks a million!! -Greg

Cheyney, That's pretty much what I'm looking to do. I have a DTS package that grabs the text file from the dumpel utility and imports it on an hourly basis. So far the table has about 5000 records since we've started the procedure. Here's how one complete record looks (tab delimited)...

I'm creating a web-based NT RAS report site and am looking for the most efficient way to import the data from NT Event log into SQL2k while formatting the data properly. I'm using the 'dumpel' utility from rsc kit and all is fine except the 10th column - the message detail: "The user...

Here's the resulting error after I changed the cast to datetime: SELECT dbo_syslogd_temp.syslog_ID, dbo_syslogd_temp.syslog_user, dbo_Users.FullName, sum(datepart(hh,cast(dbo_syslogd_temp.syslog_dur AS datetime)) * 3600 + datepart(mi,cast(dbo_syslogd_temp.syslog_dur AS datetime)) * 60 +...

I'l give it a swing ... thanks man!!!

that's the exact two functions I've been trying with no luck. Here's my current query: SELECT dbo_syslogd_temp.syslog_ID, dbo_syslogd_temp.syslog_user,cast(sum(dbo_syslogd_temp.syslog_dur) AS SumOfsyslog_dur), dbo_Users.FullName FROM dbo_Users RIGHT JOIN dbo_syslogd_temp ON dbo_Users.UserName =...

thanks for the responses. the purpose is to provide stats on total time usage for each user on daily, weekly and monthly periods. If 1 user has logged into VPN 11 times that week, the syslogs will show a new record for each session with duration info in hours:minutes:seconds format, then I want...

I'm creating a web report page for our Syslog database and want to provide user stats for VPN usage. I had to really wrangle the table to get the message detail into seperated, managable fields: username, duration, time, date, server hostname, data transmitted and data received. On any given day...

DB is SQL 2000 and I'm trying to convert a field datatype from varchar to numeric where the data is hours:minutes:seconds (05:52:12), but I run into errors with EM and scripts that the db cannot convert those datatypes. I've tried the cast function with same results ... any solutions?? I need to...