Skip navigation
1 2 Previous Next 16357 Views 16 Replies Latest reply: Nov 7, 2008 1:52 PM by Geo RSS
Geo Apprentice 33 posts since
Sep 11, 2008

Has received 1 of 9 achievements.
Currently Being Moderated

Sep 25, 2008 8:35 AM

Service Desk SQL Scripts

I'm putting together a file of Service Desk SQL Scripts and would appreciate some help. If anyone has some functional working scripts, please email them to me at geo . wassung @ naisolutions . com . Once compiled, I would be happy to post on this site.

thanks,

Geo.

  • phoffmann SupportEmployee 2,643 posts since
    Dec 11, 2007

    Has received 7 of 9 achievements.
    Currently Being Moderated
    1. Sep 25, 2008 3:17 AM (in response to Geo)
    Re: Service Desk SQL Scripts

    1 - I would recommend changing your e-mail address to something like

    
    name dot surname at-sign company dot com
    

     

    instead of

    
    name@company.com
    

     

    Pasting straight e-mail addresses into a publicly accessible forum is just inviting various spam-crawlers to start throwing more junk your way :).

     

    2 - What kind of scripts are you looking for? The way I'm reading this at the moment is essentially like "does anyone have scripts for landesk" (just that this is for SD in this case) ... well - there's always lots of scripts, the question is what kind of thing you're looking for.

     

    Paul Hoffmann

    LANDesk EMEA Technical Lead

  • kcorkran Rookie 17 posts since
    Oct 20, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    3. Oct 20, 2008 3:32 PM (in response to phoffmann)
    Re: Service Desk SQL Scripts

    Hey Paul,

     

    I would love to get a copy of whatever SQL scripts you guys have.. I just got hooked into ServiceDesk and I am looking for anything I can find to make my life a little easier...

     

    Thanks,

    Keith

  • phoffmann SupportEmployee 2,643 posts since
    Dec 11, 2007

    Has received 7 of 9 achievements.
    Currently Being Moderated
    4. Oct 22, 2008 5:16 AM (in response to kcorkran)
    Re: Service Desk SQL Scripts

    I don't have any myself (I don't have much to do with SD yet), but I'll inquire at the Service Desk folks to see if someone can have a look at this and add some "frequently used / useful" type scripts... (not sure there are any, though, since I understand that their DB is changing extremely on a per-customer basis, based on what you're doing with it exactly).

     

    Paul Hoffmann

    LANDesk EMEA Technical Lead.

  • kcorkran Rookie 17 posts since
    Oct 20, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    5. Oct 22, 2008 7:01 AM (in response to phoffmann)
    Re: Service Desk SQL Scripts

    Ok, I appreciate it..

     

    -Keith

  • Specialist 4 posts since
    Aug 13, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    7. Oct 28, 2008 5:34 AM (in response to Geo)
    Re: Service Desk SQL Scripts

    Hi there

     

    There are numerous scripts available however they all perform very specific functions which won't be relevant for a lot of customer & in many cases could do real harm if run in error.  Some are version (ServiceDesk) specific too. 

     

    Can you give me some idea of what sort of thing you could be looking for (Oracle or MS SQL?) & I'll see if there is anything which fits the bill?  One 'generic' script which I could think of would be to delete test data however we would still prefer to speak to a customer before sending it as in most cases it will require the customer to make some modifications.

     

    Kindest

     

    Louise Perrior

    Teamleader, EMEA Technical Support

    LANDesk Software UK Ltd

  • kcorkran Rookie 17 posts since
    Oct 20, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    8. Oct 28, 2008 6:42 AM (in response to lperrior)
    Re: Service Desk SQL Scripts

    Mostly I'm thinking about the scripts for repopulating the ServicePortalEndUsers role and things of that nature that need to be scheduled..

  • Specialist 4 posts since
    Aug 13, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    9. Oct 28, 2008 8:20 AM (in response to kcorkran)
    Re: Service Desk SQL Scripts

    Here you go, both of these should be useful.  Usual rules apply, strongly recommend you run them within a test environment first but at the very least, take a full, restorable DB backup prior to running on live & rollback immediately in the event of any issues.

     

    Let me know if there are any others you need.

     

    Lou

    Teamleader, EMEA Technical Support

    Attachments:
  • kcorkran Rookie 17 posts since
    Oct 20, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    10. Oct 28, 2008 2:55 PM (in response to lperrior)
    Re: Service Desk SQL Scripts

    Thanks Lou!

     

    I will definately be careful...

     

    -Keith

  • Specialist 4 posts since
    Aug 13, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    12. Nov 3, 2008 7:05 AM (in response to Geo)
    Re: Service Desk SQL Scripts

    Hi Geo

     

    Did you need any others or do you have what you require?

     

    Kindest regards

  • Specialist 4 posts since
    Aug 13, 2008

    Has received 1 of 9 achievements.
    Currently Being Moderated
    14. Nov 3, 2008 10:16 AM (in response to Geo)
    Re: Service Desk SQL Scripts

    Hi there

     

    I'm not totally sure what you mean by 'checking the mail queue' but I've attached what I think will be useful - it's referred to as the 'Mail Archive scripts' & are generally used to manage the mail backlog if MailManager has been down for any reason.  You may find that what's included here you could adapt to what you need.

     

    With regards to checking the specific content of a mail, there is no script for this & in all honesty it's never been requested.  I would expect for mail content to be checked from within your Mail Program, using the search facility there - that said, the script below for viewing outgoing mails might be useful, or indeed adaptable.

     

    I've attached a couple of other mail related scripts in case they are useful.

     

    Usual caveats as I said before, run them in a test environment first & if running in live, take a full, restorable database backup prior to doing so & restore immediately to this in the event of any failure or unexpected behaviour.

     

    Kind regards

1 2 Previous Next

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software