tag:blogger.com,1999:blog-4854976060941534129.post3179432769880031308..comments2023-06-22T05:45:12.837-07:00Comments on JJ's SQL Ethiques- Blogging SMS/SCCM: SMS Report to find machines with duplicate serial numbersAnonymoushttp://www.blogger.com/profile/05411953615495526418noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4854976060941534129.post-12534728707258636282011-12-20T11:42:52.198-08:002011-12-20T11:42:52.198-08:00Congratulations! Has been helpful for me!
thanks!...Congratulations! Has been helpful for me!<br /><br />thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4854976060941534129.post-72430411442456860032011-06-17T05:57:39.051-07:002011-06-17T05:57:39.051-07:00you can run these queries against your SMS/SCCM da...you can run these queries against your SMS/SCCM database (SQL Query Analyzer/SQL Management Studio). Or you can create this as reports in your SMS/SCCM console. <br /><br />Regarding the advertisments, you may see my below post.<br /><br />http://jj-with-mad-skillz.blogspot.com/2010/09/query-to-find-detailed-advertisement.htmlAnonymoushttps://www.blogger.com/profile/05411953615495526418noreply@blogger.comtag:blogger.com,1999:blog-4854976060941534129.post-38862988946999544112011-06-17T05:11:41.602-07:002011-06-17T05:11:41.602-07:00these queries are great...
but can you provide a d...these queries are great...<br />but can you provide a detail way of doing this...where to add or how to run these queries...<br />I am new to sccm and would like to know how we can see the details of the advertised programs as some of the clients receives the advertisement within 2-3 min and some takes long time for this is there a way by which i can track the process which are going on after the advertisement is made...<br /><br />thanks & regards,<br />pranay bhagatAnonymousnoreply@blogger.com