You could also do this as a query in the console.
On Tue, Mar 17, 2015 at 11:32 AM, Daniel Ratliff
wrote:
> I use this SQL query to look for multiple records by MAC in the
> database. I made it into a SSRS report for easy consumption. Just modify
> the MAC at the end.
>
>
>
> select SYS.netbios
Matt, I think you are under the mistaken impression that I know what I'm doing.
:)
I stumble through; and only know that trick above because I remembered "hey,
John Nelson did this with IP addresses... let me search for that..." which led
me to http://www.myitforum.com/forums/IP-Address-Query-
Thanks Daniel, I added that as a command line just before the
checkbadkb.ps1 script, and the script seems to be running successfully now.
John - Checkbadkb.ps1 sets a TS Variable WUMUExcludeKB for each patch to be
excluded. Based on the article, it looks like the ZTIWindowsUpdate.wsf
script fro
It appears to be the tail end of the replace function:
https://msdn.microsoft.com/en-us/library/ms186862.aspx
REPLACE ( string_expression , string_pattern , string_replacement )
Replace(
string_expression = (Select c.name + ', ' from v_collection c join
v_fullcollectionmembership fcm on fcm.c
SMSMP=
These are all the switches I am using
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . .
Jason King | Solutions Design Team
Telephone: 248.853.4841
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.co
xposted from the technet forums:
I've started getting an intermittent error editing my Windows 7 OSD task
sequence. Sometimes I can open the TS to edit, but when I try to apply
changes I get the error. Other times I get the error when trying to open
the TS. If I try again right away, I still ge
Whats your full switches look like in Setup Windows and ConfigMgr?
Daniel Ratliff
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of King, Jason
Sent: Tuesday, March 17, 2015 2:55 PM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: Install Updates dur
So I thought I had it and it looks like I still don’t. I have the SMSMP string
in there but that does not seem to help. Here is the error I get from Location
Servers Log
Error Sending HEAD request: HTTP Code 401, Status ‘Unauthorized’
. . . . . . . . . . . . . . . . . . . . . . . . . . . . .
That did the trick. I did have to further modify available values in the report
in SSRS to reflect the domain name scheme changes since you used a different
view for that.
Any chance you can explain what this portion was for? I can see the reason for
everything except this:
)+'..',', ..','')
oh. take out all the ' surrounding your @prompts. I added those in. for
testing, I had real values in there that made sense in my lab.
On Tuesday, March 17, 2015 12:24 PM, "Atkinson, Matt T"
wrote:
It throws an error:
Error in WHERE clause near '('.
Unable to parse query text.
Computer Agent -> Powershell execution policy, set to Bypass.
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Bradley, Matt
Sent: Tuesday, March 17, 2015 10:11 AM
To: mssms@lists.myitforum.com
Subject: RE: [External] [mssms] RE: KB detection clause
I typ
It throws an error:
Error in WHERE clause near '('.
Unable to parse query text.
I’ll try to keep poking at it and see if I can figure it out.
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Sherry Kissinger
Sent: Tuesday, March 17, 2015 6:20 AM
To: mssms
I typoed when doing the email, but I've got it correct in SCCM.
Thanks for checking on your side. Did you have to adjust your default client
settings for PowerShell to make this run?
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Bull, John
Sent: Tues
This works for me:
Get-HotFix | Where-Object {$_.HotfixID -eq 'KB2834140'}
I believe your missing the period after the underscore.
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Bradley, Matt
Sent: Tuesday, March 17, 2015 9:38 AM
To: mssms@lists.myitfo
In trying to devise a detection clause for an .exe KB deployment, I came across
this page
(http://myitforum.com/myitforumwp/2013/06/18/deploying-microsoft-hotfixes-via-the-configmgr-2012-app-model-28/
) detailing a one line PowerShell command:
Get-HotFix | Where-Object {$_HotfixID -eq 'KB123456
Some typo's, I corrected them.
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com]
On Behalf Of Robert Spinelli
Sent: Tuesday, March 17, 2015 12:01 PM
To: mssms
Subject: [mssms] OffTopic - Symbolic Link
I'm creating a symbolic link using the command below:
mkli
I use this SQL query to look for multiple records by MAC in the database. I
made it into a SSRS report for easy consumption. Just modify the MAC at the end.
select SYS.netbios_name0 WKID, SD.itemkey ResourceID, MAC.MAC_Addresses0,
SD.SMS_Unique_Identifier0,SD.Hardware_ID0,SD.Name0,SD.Unknown0,SD
PXE Anywhere Ed, not installing PXE Everywhere. ;-)
//A
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Ed Aldrich
Sent: den 17 mars 2015 16:42
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM 2012 R2 and PXE boot
Dunno if the details in this blo
I’m actually working on a session covering this for our usergroup meeting in
april.
I will have my slidedeck and notes / scripts posted and will reply to this
thread once they are live.
I use mdt since i sometimes need to image computers without the configmgr
client on them.
It also lets me us
Make sure the system you are attempting to PXE boot is in an appropriate device
collection for the Task Sequence you want to run in a PXE process. If it is a
new system (or unknown) to SCCM, make sure you are setup to handle unknown
systems.
One thing I noticed going to R2 (and I will admit it
..and if you don't like reading, or just plain can't be bothered - Junior did a
movie as well!
Describes the problem and fix/workaround quite nicely. Bear in mind that your
DHCP server needs to be WS2012 for this to work..
Using DHCP to Boot WDS BIOS & UEFI
https://youtu.be/k5E97ndlRog
cheers
I'm creating a symbolic link using the command below:
mklink F:\PackageSource\SWDistribution\MakelinkTest\SCCM\7z920.exe
F:\PackageSource\SWDistribution\MakeinkTest\7z920.exe
It does get created, and if I run 7z920.exe from a command line it launches,
but if I double click on
F:\PackageSour
Dunno if the details in this blog post will be of any help. There is quite a
bit of background info on the subject of PxE booting and DHCP.
http://www.1e.com/blogs/2014/09/29/osd-pxe-ip-helpers-dhcp-options-isnt-there-a-better-way/
FWIW
Ed Aldrich | Channel Solutions Engineer | 1E
+1 (401) 924-
A little white paper on the subject, more posts coming the coming days:
http://2pintsoftware.com/new-whitepaper-using-dhcp-to-control-uefi-bios-pxe-booting/
//A
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Andreas Hammarskjöld
Sent: den 21 januari 20
I come up with this. It works.
SELECT IP_Subnets0 AS 'Subnets Detected',
vSMS_Boundary.Value AS 'Boundary Values',
COUNT(ResourceID)AS 'Count of Devices on Subnets Detected'
FROM v_RA_System_IPSubnets
Full Join vSMS_Boundary on vSMS_Boundary.Value = v_RA_System_IPSubnets.
IP_Subnets0
Group By
Be advised though there are some things that don’t migrate as smoothly. If you
have MDT-integrated Task Sequences in particular, you may hit some snags.
-Phil
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Todd Hemsell
Sent: Monday, March 16, 2015 1
I'm working on trying to publish the new Surface Pro Firmware .msi as a
software update via SCUP. In addition to the built in msi product code
detection method I want to add a rule so that it only shows as applicable
on Surface Pro 3s. I've got how to detect the model name from WMI, but I
am havi
This should be pretty close:
select
sys1.resourceid,
sys1.Netbios_Name0 as 'Name',
sys1.Resource_Domain_OR_Workgr0 as 'Domain',
sys2.SystemRole0 as 'SystemRole',
os.Caption0 as 'Caption',
cs.lastpolicyrequest as 'Last Policy Request',
Replace((Select c.name + ', ' from v_collection c
Thanks for the reply. I have found a boundary that did not exist and has
about 500 devices on it. When I spot checked computer names in SCCM, they
were reporting in, sending inventory, and getting software package
distribution. I was baffled. My searching found only a few way you could
assign a co
29 matches
Mail list logo