Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pork1977

    Get DateLastModified and ProductVersion from FTP location

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

    Get DateLastModified and ProductVersion from FTP location

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

    Get DateLastModified and ProductVersion from FTP location

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

    Troubles running MSI with PsExec within a vbscript

    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 =...
  5. pork1977

    Troubles running MSI with PsExec within a vbscript

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

    Crosstab Formulas

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

    Crosstab Formulas

    +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
  8. pork1977

    Crosstab Formulas

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

    Crosstab Formulas

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

    Crosstab Formulas

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

    Crosstab Formulas

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

    Finding the difference between 2 date ranges

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

    Crosstab Formulas

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

    Finding the difference between 2 date ranges

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

    Finding the difference between 2 date ranges

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

    Finding the difference between 2 date ranges

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

    Finding the difference between 2 date ranges

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

    Finding the difference between 2 date ranges

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

    auto ftp download

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

    auto ftp download

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

Part and Inventory Search

Back
Top