tag:blogger.com,1999:blog-15559937.post3903714108859650103..comments2024-02-19T07:53:28.238-05:00Comments on Plain Text Prose: sccm: integrating dell warranty data into configmgrMarcus Ohhttp://www.blogger.com/profile/16669592705989568859noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-15559937.post-39554710681878570432012-09-18T17:39:16.493-05:002012-09-18T17:39:16.493-05:00Would there ever be any interest in correcting the...Would there ever be any interest in correcting the problem where Dell lists the first year of warranty separate from the second and subsequent years? I modified the the old VBScript stuff to merge the dates in two rows when the descriptions were the same, but I don't know powershell well enough to do the same. This made it so that the warranty type went from the ship dat to the end date without having double rows for a single warranty type (active and future)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15559937.post-31506182438734543382012-07-18T11:06:47.099-05:002012-07-18T11:06:47.099-05:00Hi Dude,
This is Rakesh.I got the answer. it ran ...Hi Dude,<br /><br />This is Rakesh.I got the answer. it ran successfuly with expected outputs. Thank you so much for creating such a good script.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15559937.post-73862314338828790972012-07-18T08:04:27.104-05:002012-07-18T08:04:27.104-05:00Hi,
this is Rakesh again. can you discribe more a...Hi,<br /><br />this is Rakesh again. can you discribe more about your script that where i can declare parameters for database server and database name.I will appreciate your help.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15559937.post-78467033597176189852012-07-18T06:07:36.149-05:002012-07-18T06:07:36.149-05:00hey rakesh -- that is correct. you can use either ...hey rakesh -- that is correct. you can use either method. the one here uses scott's sql method. mine is modified a little bit to handle delta changes.Marcus Ohhttps://www.blogger.com/profile/16669592705989568859noreply@blogger.comtag:blogger.com,1999:blog-15559937.post-9893356711005120162012-07-17T06:30:26.913-05:002012-07-17T06:30:26.913-05:00HI,
This is Rakesh. as per my understanding if i ...HI,<br /><br />This is Rakesh. as per my understanding if i use the above script, no need to use scott's script which runs on client machines using SCCM software distribution method. only run the above script(created by you) on SCCM database server which provide the same information as Scott's script.<br />Please correct me if my understanding is incorrect.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15559937.post-29458970120665355142012-05-07T12:28:33.120-05:002012-05-07T12:28:33.120-05:00no, it's not necessary. you only need powershe...no, it's not necessary. you only need powershell on the machine where the script is running -- which should be your configmgr server in most cases.Marcus Ohhttps://www.blogger.com/profile/16669592705989568859noreply@blogger.comtag:blogger.com,1999:blog-15559937.post-70023893816699167792012-05-07T12:27:53.922-05:002012-05-07T12:27:53.922-05:00the steps for implementing are located here: http:...the steps for implementing are located here: http://myitforum.com/cs2/blogs/skeiffer/archive/2011/05/11/dell-warranty-info.aspx<br /><br />my article is a revision to make it work in a "delta" like update.Marcus Ohhttps://www.blogger.com/profile/16669592705989568859noreply@blogger.comtag:blogger.com,1999:blog-15559937.post-8499636696177819382012-05-07T05:12:30.559-05:002012-05-07T05:12:30.559-05:00Also do we need to install Windows Power Shell on ...Also do we need to install Windows Power Shell on all Dell machines to make the script workAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15559937.post-18406140680730808862012-05-07T05:10:29.901-05:002012-05-07T05:10:29.901-05:00Please share the step by step method how to use yo...Please share the step by step method how to use your script in our enviroment with SCCM to fetch Dell warranty info as the Dell Website has again changed.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15559937.post-13645483429762427112012-03-06T13:57:15.587-05:002012-03-06T13:57:15.587-05:00that's kind of weird. i don't recall havin...that's kind of weird. i don't recall having to do that ... but thanks for the update.Marcus Ohhttps://www.blogger.com/profile/16669592705989568859noreply@blogger.comtag:blogger.com,1999:blog-15559937.post-89387113824056452422012-03-02T15:06:11.031-05:002012-03-02T15:06:11.031-05:00The account running the script needs db_owner righ...The account running the script needs db_owner rights in the database. I was getting duplicate records each time it ran with the account having db_datareader and db_datawriter privileges. Once I made the account a db_owner I stopped getting duplicate records.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15559937.post-49218011441002874572011-08-19T14:00:34.116-05:002011-08-19T14:00:34.116-05:00thanks. i updated it because of your comment -- bu...thanks. i updated it because of your comment -- but basically the reports included in scott's post work exactly alike here. i just modified the script to work in a different way.Marcus Ohhttps://www.blogger.com/profile/16669592705989568859noreply@blogger.comtag:blogger.com,1999:blog-15559937.post-73393793944000784022011-08-19T11:17:42.374-05:002011-08-19T11:17:42.374-05:00Looks like an interesting script. How do I impleme...Looks like an interesting script. How do I implement this in to SCCM?Anonymousnoreply@blogger.com