Hi Nikhil,
you can built a custom workflow and use a PowerShell script for that. I haven't done this personally, but it is worth a try. Here a good reference:
Service Manager Workflows – Part 1
http://marcelzehner.ch/2011/01/17/service-manager-workflows-part-1/
Hope this helps.
Regards,
Stoyan (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!)