Search results for query: *

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...

Hello, I'm using VB 6 on a W2000 PC. I've been given a small VB project and would like to compile and run the app but when I try to load the form I get the following error: Cannot load control Winsock1; license not found. I have added Microsoft Socket Control from the Project->Components menu...

Hello, I'm using Crystal 8.5 against Oracle 8.0.4 and a CSV file. The database ( used in my main report ) and CSV file ( used in my sub-report ) have no logic link so I've had to create on using weeknumber, this works fine and displays all the information I need. I've created a shared variable...

I'm getting an Oracle error message when I try to amend the SQL generated from Crystal. I'm using Oracle 8.0.4, Crystal 8.5 connecting via the microsoft ODBC connection. The original sql is: SELECT REPORTING_DATES."REPORTING_DATE", INCIDENT."INCIDENT_REF" FROM...

Sorry, this won't work. There is not always data for each period or each TSL attainment. So if I summarise the data I have I get: Period 04 Outside TSL 3 Inside TSL 1 Period 06 Outside TSL 1 Period 9 Inside TSL 1 etc... Any ideas?

Hello, I'm running Crystal 8.5 against Oracle 8.0.4. The data I have is: Ticket id Inside/Outside TSL Date logged What I currently get is: 1 Outside TSL Period 3 2 Outside TSL Period 3 3 Outside TSL Period 3 4 Inside TSL Period 3 5 Outside TSL Period 4 6 Outside TSL Period 5 The graph I...