Recent content by BarryCrosby

I'm a complete noob when it comes to powershell. I've got a requirement to create a CSV file of all active users from AD including the line manager attribute, however I need the line managers sAMAccountName not the cn. Here is what I have so far: Get-ADUser -server server_ip -Filter { mail...

Thanks Roy-Vidar using count(*) does the trick, Apologies for putting it in the wrong forum. I've joined the VBScript one now, so will use this in future. Barry

Hi, I have the following script to connect to a database to check a value that has been submitted via an input box. The three scenarios are: 1) A single match exists 2) Duplicate matches exist 3) No matches exist However when I am trying to test scenario all I get is a record count of -1...

Hi, Sorry if this is not the correct forum but I need a quick query answered and this seemed like the best forum to use. If not point me in the right direction and I will post it elsewhere. Basically i'm runnig the xml export from cisco works and getting an entry for a Hardware Platform/Model...

Help, I'm using Crystal V9 and i've been asked to create a report that contains hyperlinks to different sections within a report. The only solution I can find in help is On Demand Sub reports which may work. However the user wants to export the report as HTML and retain the hyperlinking. Is...

Hiccup, How do I change the FROM or SENDER from the mailbox it is sent from to a specific mailbox? Basically I need to be able to set the SENDER property but I cannot find out how to do it using MAPI or createobject. Thanks, B

klornpallier, I've tried using MAPI but there is no way to change the FROM user ( SENDER ). Any ideas?

All, I'm trying to send an email from my little app but am having difficulties. I do not have the full version of VB 6, only the child version so cannot use winsock. I have tried using MAPI but cannot set the FROM or SENDER, I know i'm doing something wrong but not sure what. I've also tried...

Thanks Dimandja, Not sure why I didn't try this in the first place. B

All, Anyway I can set the email address using MAPI? Currently when I use: objrecipient.name = "Barry Crosby" The address comes up as the system address not the email address as I expected. Is there anyway I can set the email address using MAPI e.g objrecipient.emailaddress =...

Thanks for all the advice. Looks like my code need s bit tidying up. Cheers, B

All, Thanks for the helpful posts. I actually found that by chaning the SQL to be: SELECT * FROM SA.INCIDENT INCIDENT WHERE INCIDENT.INCIDENT_REF = 323455 And then used: Do While Not rs.EOF row = "" For icount = 0 To rs.Fields.Count - 1 row = row & rs.Fields(icount).Value strIncID =...

Here's the code: Set db = New ADODB.Connection With dlg_incref If dBase <> "" Then Conn = "UID= " & uid & ";PWD=" & pwd & ";DRIVER={Microsoft ODBC For Oracle};" _ & "SERVER=" & dBase & ";" Else Conn = "UID= " & uid...

Sorry I forgot to add if I paste the code in SQLPlus it retrieves all the INCIDENT_ID's successfully. Thanks, Barry

All, I've got a problem with a piece of code accessing an oracle database. I've used the same piece of code to access other tables and it returns data successfully but when I try the following it errors saying: Either BOF or EOF is true, or the current record has been deleted. Requested...