SCCM Query for total count of OS and Service Pack

﹏ヽ暗。殇╰゛Y 2022-10-01 13:49 20阅读 0赞

This SQL query can be used to find the overall count of Operating systems and their Service packs

SELECT Caption0 as 'Operating System',CSDVersion0 as 'Service Pack', COUNT(\*) AS 'Count'  
FROM v\_GS\_OPERATING\_SYSTEM,v\_R\_System  
WHERE v\_GS\_OPERATING\_SYSTEM.Resourceid=v\_R\_System.Resourceid  
GROUP BY Caption0,CSDVersion0  
ORDER BY Caption0,CSDVersion0

[![clip\_image002][clip_image002]][clip_image002_clip_image002]

[http://myitforum.com/cs2/blogs/andersonk/archive/2010/01/22/sccm-query-for-os-and-service-pack-with-count.aspx][http_myitforum.com_cs2_blogs_andersonk_archive_2010_01_22_sccm-query-for-os-and-service-pack-with-count.aspx]

转载于:https://blog.51cto.com/prain/271300

[clip_image002]: https://s1.51cto.com/attachment/201001/27/162681_1264603653MQdF.gif
[clip_image002_clip_image002]: https://s1.51cto.com/attachment/201001/27/162681_126460365398Vd.gif
[http_myitforum.com_cs2_blogs_andersonk_archive_2010_01_22_sccm-query-for-os-and-service-pack-with-count.aspx]: http://myitforum.com/cs2/blogs/andersonk/archive/2010/01/22/sccm-query-for-os-and-service-pack-with-count.aspx

发表评论取消回复

表情：

评论列表（有 0 条评论，20人围观）

还没有评论，来说两句吧...

相关阅读

相关 sqlzoo:SUM and COUNT

> 1. Show the total population of the world. SELECT SUM(population) FROM world

梦里梦外;/ 2022年12月27日 01:50/ 0 赞/ 182 阅读

相关 MySQL踩坑笔记之Pack for query is too large

MySQL踩坑日记之Pack for query is too large 引言问题解决办法引言今天在做联行号入库

怼烎@/ 2022年12月17日 04:29/ 0 赞/ 38 阅读

相关 aspose.total for C++ Crack

C ++的Aspose.Total包括以下C ++库：-----内容来自互联网，敬请留意 Aspose.Words for C ++ 一个C ++类库，程序员可以直接从C

梦里梦外;/ 2022年11月01日 04:18/ 0 赞/ 244 阅读

相关 SCCM Query for total count of OS and Service Pack

This SQL query can be used to find the overall count of Operating systems and their Serv

﹏ヽ暗。殇╰゛Y/ 2022年10月01日 13:49/ 0 赞/ 21 阅读

相关 Rebex Total Pack for .NET Crack

Rebex Total Pack for .NET File Server--Ω578867473 SFTP, SCP and SSH server component

曾经终败给现在/ 2022年09月04日 01:46/ 0 赞/ 245 阅读

相关 VS.NET 2003 Service Pack 1

[http://www.microsoft.com/downloads/details.aspx?FamilyID=69d2219f-ce82-46a5-8aec-072bd4

青旅半醒/ 2022年08月26日 04:50/ 0 赞/ 203 阅读

相关 Counting positive and negative number and computing the average of numbers

代码： import java.util.Scanner; public class Ten_six {

雨点打透心脏的1/2处/ 2022年08月09日 02:19/ 0 赞/ 222 阅读

相关 Better modelling and visualisation of newspaper count data

(This article was first published on [Quantifying Memory][], and kindly contributed to

川长思鸟来/ 2022年08月05日 12:19/ 0 赞/ 198 阅读

相关 Images and Mouse Events(Chapter 18 of Cocoa Programming for Mac OS X)

1 \import " StretchView.h " 2 3 4 @implementation StretchView

绝地灬酷狼/ 2021年11月10日 00:24/ 0 赞/ 120 阅读

相关 Nib Files and NSWindowController(Chapter 12 of Cocoa Programming for Mac OS X)

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][] PreferenceController 1 \import

缺乏、安全感/ 2021年11月10日 00:22/ 0 赞/ 178 阅读