|
Browse by Tags
All Tags » SCCM ( RSS)
-
|
There is a poll on myITforum that talks about Certification and System Center. Basically what it wants to know is What SC certs do you hold and if you have any Windows 2008 MCITPs http://www.myitforum.com/absolutenm/templates/site.aspx?articleid=19149&zoneid...
|
-
|
So, my test lab has been running lean and mean for a while. A few weeks back I decided that in order to test ConfigMgr v.Next. I needed to update my lab. In the past I had a few discussion about Hyper-v and getting more performance out of it. The...
|
-
|
select * from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId where ...
|
-
|
select * from dbo.v_GS_NETWORK_ADAPTER_CONFIGUR where IPAddress0 IS not NULL and IPAddress0 like '192.168.[1-9].%'
|
-
|
I have decided that the forums on www.SMSUG.ca are not being used and due to some SPAMMER populating the membership list, I have closed them down. This is a good thing as it means I will arrange for the site to be convert to a blog only site. With the...
|
-
|
select C.Collectionid, C.Name from dbo.v_Collection C Where C.Collectionid not in (Select Collectionid from dbo.v_FullCollectionMembership)
|
-
|
select CS.Name0, NAC.IPAddress0 from dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC Join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = NAC.ResourceID Where IPAddress0...
|
-
|
Select Distinct sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0...
|
-
|
select NAC.DNSHostName0, count(NAC.ResourceID) from dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC Where IPAddress0 is NOT NULL Group by NAC.ResourceID, ...
|
-
|
The ConfigMgr / SCCM documentation script has been updated to v1.24 for more details please see http://tinyurl.com/yfpgocw
|
-
|
SELECT Distinct sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, ...
|
-
|
This might NOT list all routers in your environment, and it will has lots of false positives too. Of the 7 device marked as a router, only 3 are right, the remaining 4 are false positives. In my test lab it found 3 out of 7, Routers /Switches...
|
-
|
With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Why do I do it? Well as a past User Group leader for www.OWSUG.ca , I know...
|
-
|
select R.* from SMS_R_System R where R.SystemGroupName != "GARTEK\\Domain Admins" and R.ResourceId not in ( select ...
|
-
|
SELECT DisplayName0, Count(*) AS 'Count', Publisher0, @CollID as CollectionID FROM v_Add_Remove_Programs arp JOIN v_FullCollectionMembership...
|
More Posts Next page »
|
|
|