tag:blogger.com,1999:blog-2071910550668491968.post754005879438150792..comments2024-02-06T02:20:07.882+11:00Comments on Venu Singireddy's blog: SCCM report Query for Computer Manufacturer, Model and total number of machinesUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2071910550668491968.post-17179984614617954592017-08-23T01:46:25.622+10:002017-08-23T01:46:25.622+10:00SELECT Manufacturer0, Model0, Count(Model0) AS ...SELECT Manufacturer0, Model0, Count(Model0) AS 'Count'<br />FROM dbo.v_GS_COMPUTER_SYSTEM<br />GROUP BY Manufacturer0,Model0<br />ORDER BY Model0<br /><br />Comes back with this error: what am I missing? <br />Msg 208, Level 16, State 1, Line 1<br />Invalid object name 'SMS_R_System'.Anonymoushttps://www.blogger.com/profile/13230050461700794539noreply@blogger.comtag:blogger.com,1999:blog-2071910550668491968.post-45817279127277523082014-06-17T22:35:13.516+10:002014-06-17T22:35:13.516+10:00really useful... thanks. really useful... thanks. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2071910550668491968.post-67118283377710372972013-10-29T22:18:28.052+11:002013-10-29T22:18:28.052+11:00Valuable blog! This query display the details of c...Valuable blog! This query display the details of <a href="http://www.eqatar.com/Computers/c-20.html" rel="nofollow">computer hardware manufacturers</a> and other hardware details.<br />Dunitz Sandrinohttps://www.blogger.com/profile/15217256296255576455noreply@blogger.com