Search results for query: *

To complete this thread, I found there was no easy way to do what I wanted, I came up with the below script though so thought I'd post here to help others. I'm sure there's lots of ugly things in this script which more experienced guys will notice, like duplication of parts which might not...

Edited a section: (see below) so "\\servername\releases\example folder" was something like "ftp://username:password@ftp.example.com/example folder"

Hi there, I'm wondering if this is possible... I'm hoping to use this as part of a custom action within an InstallShield solution if so. So at the moment I have the following vbscript which basically does 2 things for me... The first part looks at a folder path on the network and then gets the...

Not to worry, managed to do what I wanted to in the end with a little bit more research. Ended up like this: (put up incase anyone was interested, and for my own reference! although this is a cut down version of what I ended up) strPSExec = "C:\psexec.exe" strMSI = "C:\MyMSI.msi" strAdminUser =...

Hi, Wondered if somebody could kindly fix this up for me? All I'm tryinng to do is push out a MSI using the PsExec tool remotley to other servers on the network. I currently have it working as I need to in a batch file but need to convert this to a vbscript and my knowledge with vbscript isn't...

OK, it does work correctly! I was just mis counting some numbers somewhere. Thanks alot for the help, the code will be useful for similiar reports. Regards, Paul

+20 gives me nothing! but +1 gives me the correct groups. Numbers don't tally up with what I expected though. I'll have a look through the CR help section to see if I can get to the bottom of it, thank you for your help. Paul

OK I will do that, would you mind explaining the formula and how it works?

OK, click on the link below to see a screenshot of what I done so far. http://pork.andym.co.uk/ This is showing any call that has got the "Forwarded to Group HARMONI ITS" in it. It show's way more in the Harmoni ITS group obviously because that's where you'd expect to see them but it also...

OK, so I tried the first formula you gave and it seems to come back with thousands of records, infact if I let it go Crystal normally crashes out because so many! I have put a sum on it but not sure why it's happening. The description field isn't a field that can be browsed through Crystal...

Thanks for your comment lbass, the description field is chosen from a list so you can't put what you want as this is the groups you can assign calls to so they always stay the same. I'll try what you say tomorrow when back in the office and see if it works but previously I had tried the...

That's great, I wasn't expecting that! I'll try it when I get back in the office tomorrow and will let you know the outcome Regards, Paul

Hi all, I have a problem with a crosstab report, the below show's an example of how it should look. Dec 06 Jan 07 ADASTRA 7 4 DEVELOPMENT 1 4 HELPDESK 22 34 IT SUPPORT 3 1 LOCAL IT 1 0 The numbers relate to the number of...

Well, just thought I'd let you know that I've worked around the problem by just deciding to do... DateDiff ("s", {Incident.Open Date & Time}, {Incident.Close Date & Time}) Unfortunatly it keeps the stoppage times in the results by doing it this way but is ok for the time being. It seems to be...

Silly me, just thought, the format of the @diff formula will need to be in 'Number' format as couldn't have the difference being in a date format! Still working on it...

Robbie, thanks for the help, that bit of code was quite useful. I have tried it, I put it into a new formula field called "@diff" but when I preview it I get the value "0.00" It doesn't seem to be recognising it as a datetime formula? as I noticed when hovering the mosue over the new formula...

I've just tried splitting the formula so that now one gets me the start_clock time and the other gets me the stop_clock time then I added a third that would show the difference between them. Didn't think it would work and it didn't as all I got was a load of 0.00 values, not having much luck, I...

Hi all, I will explain the scenerio first as I don't think I can explain the problem without doing so. I work on a helpdesk that uses call logging software to log calls. These calls can be placed in a HOLD status and when they are, the clock time stops as each one will have specific SLA's to...

Sorry PHV, can you elaberate I am none the wiser yet

Hiya, I was wondering, my knowledge with vbscript is not too good and as of current I'm trying to create a script that when run automaticaly downloads all files in the root of the ftp location just to the root of my c drive - have done some digging around and come up with this script which...