Recent content by SW2004

Hi tsuji, Many thanks for the code, would you mind describing how it works? Thanks for your time. Steven

Hi tsuji, Thanks for that, as there are so many characters that aren't ascii is there a way to tell VBScript to process this line in UTF-8? Otherwise I would need to check for all characters with accents etc and replace them with the UTF-8 code, would I? Many thanks. Steven

Hi all, I’m using the following VBscript to find a user within Active Directory which works fine so long as the CN value doesn’t contain a character with an accent (French, German etc), in the example below I’ve used Léo Apotheker, unfortunately the letter é produces an ‘Object not found...

Hi all, I’m using the following VBscript to find a user within Active Directory which works fine so long as the CN value doesn’t contain a character with an accent (French, German etc), in the example below I’ve used Léo Apotheker, unfortunately the letter é produces an ‘Object not found...

I'll try what you suggest later today, thanks for that. Steven

Hi, I have a VB app that sets an account expiry date for Active Directory accounts however if I don't specify an expiry date then the account is set to expire on 28th Dec 1899! (I believe this is a cdate or isDate issue). I've narrowed the fault down to the code below, if the code below is...

Thanks PHV I now receive the error 'object doesn't support this property or method', any ideas what could be amiss? I feel like I'm 99% there. 'Read Machine Name Set objComputer = CreateObject("Shell.LocalMachine") SQLQuery = "insert into Audit_Table (MachineName) values('" & objComputer &...

Can anyone help me with the following, when I try to write the PC name to a SQL database I get the message that column names are not permitted only variables, what's wrong with my code? I suspect it's the formatting of the (objComputer). Many thanks 'Read Machine Name Set objComputer =...

That's just what I needed, many thanks.

Hi I have the following script which reads the machine name and then looks up the BIOS version on the PC, currently it only echo the results. I have a SQL server available to me, how would I connect to the server and write the results to the database? I've looked hi and low on MSDN and can't...

Hi, I have a layer 3 switch (3com 7700). I want to segment the switch so fibre port 2 (1/1/2) is in 1 VLAN and fibre port 3 is in another (1/1/3). This is purely for broadcast reasons at the moment. I have port 2 assigned to VLAN 2 & Port 3 assigned VLAN 3. What are the commands to allow traffic...

Hi, I have a web site that I wish to secure using a certificate that is distributed via e-mail. The recipient of the e-mail installs the certificate and they can then access the site. I've seen it done before when we subscribed to http://www.screenonline.org.uk/ in order to access the videos...

Many thanks for the help.

Hi, I'm trying to find all faults in my helpdesk database that have been completed today. The query below doesn't return anything even though there are completed faults today. Can anyone help? Thanks. SELECT [date fault reported], [date fault completed], [fault number], [status] FROM [fault...

Hi Ru55ell, Can you explain Global Level and Interface Level? Also when you say you trunk VLANs to the edge does this mean you configure the edge switches with the corrosponding VLAN info? Thanks for all the advice. S