I have been trying to use this guide from Microsoft but I've not been able to get it to work with sysprep, unattend.xml and the CopyProfile Parameter.

http://support.microsoft.com/kb/973289

Any ideas?

Best regards
Hans Chr. Andersen

The TFTP services are running also. How would I enable port 69 on the server?

 No.     Time           Source                Destination           Protocol Info
   1069 30.651448665   10.1.201.2            10.1.4.116            TFTP     Read Request, File: SMSBoot\x64\wdsnbp.com\000, Transfer type: octet\000, 0=0\000

Frame 1069 (89 bytes on wire, 85 bytes captured)
Ethernet II, Src: Dell_e5:f3:8b (00:15:c5:e5:f3:8b), Dst: Dell_e5:30:78 (00:15:c5:e5:30:78)
    Destination: Dell_e5:30:78 (00:15:c5:e5:30:78)
        Address: Dell_e5:30:78 (00:15:c5:e5:30:78)
        .... ...0 .... .... .... .... = IG bit: Individual address (unicast)
        .... ..0. .... .... .... .... = LG bit: Globally unique address (factory default)
    Source: Dell_e5:f3:8b (00:15:c5:e5:f3:8b)
        Address: Dell_e5:f3:8b (00:15:c5:e5:f3:8b)
        .... ...0 .... .... .... .... = IG bit: Individual address (unicast)
        .... ..0. .... .... .... .... = LG bit: Globally unique address (factory default)
    Type: 802.1Q Virtual LAN (0x8100)
802.1Q Virtual LAN, PRI: 0, CFI: 0, ID: 1
Internet Protocol, Src: 10.1.201.2 (10.1.201.2), Dst: 10.1.4.116 (10.1.4.116)
User Datagram Protocol, Src Port: gxs-data-port (2073), Dst Port: tftp (69)
    Source port: gxs-data-port (2073)
    Destination port: tftp (69)
    Length: 47
    Checksum: 0x3bec [correct]
Trivial File Transfer Protocol

No.     Time           Source                Destination           Protocol Info
   1070 30.651710989   10.1.4.116            10.1.201.2            ICMP     Destination unreachable (Port unreachable)

Frame 1070 (117 bytes on wire, 113 bytes captured)
Ethernet II, Src: Dell_e5:30:78 (00:15:c5:e5:30:78), Dst: Dell_e5:f3:8b (00:15:c5:e5:f3:8b)
    Destination: Dell_e5:f3:8b (00:15:c5:e5:f3:8b)
        Address: Dell_e5:f3:8b (00:15:c5:e5:f3:8b)
        .... ...0 .... .... .... .... = IG bit: Individual address (unicast)
        .... ..0. .... .... .... .... = LG bit: Globally unique address (factory default)
    Source: Dell_e5:30:78 (00:15:c5:e5:30:78)
        Address: Dell_e5:30:78 (00:15:c5:e5:30:78)
        .... ...0 .... .... .... .... = IG bit: Individual address (unicast)
        .... ..0. .... .... .... .... = LG bit: Globally unique address (factory default)
    Type: 802.1Q Virtual LAN (0x8100)
802.1Q Virtual LAN, PRI: 0, CFI: 0, ID: 1
Internet Protocol, Src: 10.1.4.116 (10.1.4.116), Dst: 10.1.201.2 (10.1.201.2)
Internet Control Message Protocol
    Type: 3 (Destination unreachable)
    Code: 3 (Port unreachable)
    Checksum: 0xdeb5 [correct]
    Internet Protocol, Src: 10.1.201.2 (10.1.201.2), Dst: 10.1.4.116 (10.1.4.116)
    User Datagram Protocol, Src Port: gxs-data-port (2073), Dst Port: tftp (69)
        Source port: gxs-data-port (2073)
        Destination port: tftp (69)
        Length: 47
        Checksum: 0x3bec [correct]
    Trivial File Transfer Protocol

Thanks.

 Some may direct me to Compliance 8 - Computers in a specific compliance state for an update list which gets me partly there.  It gives me a list of computers that need one or more updates in the specific update list.  However, if I click on a machine in the report, it opens the Compliance 6 - Specific computer report, which lists updates that are required (based on client scan) but not based on Update list (what has been approved, if you will).

 Assuming I have not overlooked an existing report (please let me know if so) can anyone with SQL query skills assist in writing such a query?  In my "non-SQL skills havin" layman's terms, it would be something like:

 join systems and updates tables

 Select systems where updates = required AND updates exist in update list

 Thanks in advance,

Steve

The compliance 6 report shows what is "required", which I assume is what Windows Update (Microsoft) would say is required.  I need something that will show me what updates are "required" AND are contained in my update list (approved).  

Yes, if Compliance 6 can be modified to produce that data I would be completely satisfied.

Steve

WIll you be happy with a modified "compliance 6" report that scans the system against approved updated on the specified update list?

Thanks,

Tom

Does anybody have a report which displays the updates status from all deployments in a single report?
I have deployments for each months Windows updates and would like a report on all there status (Installed, Required, Not Required, etc) from one report.

I have tried modifying the report 'Updates in a deployment' without much luck.

Thanks

John

Try this link

 http://blog.coretech.dk/confmgr07/config-mgr-inventory-and-reporting/status-report-for-software-update-deployments/

Hope it helps.

Cheers,
Kenneth

Thanks for posting, unfortunately when I paste the code in a new report its coming back with an empty 'Report SQL Statement' error.

Any chance you could post it in a pastebin incase the syntax changed/modified?

Thanks

John

Try this report:

The SQL code:

Select Deploymentname, Available, Deadline,

cast(cast(((cast([Compliant] as float) / (ISNULL([Compliant], 0) + ISNULL([Enforcement state unknown], 0) + ISNULL([Successfully installed update(s)], 0) + ISNULL([Failed to install update(s)], 0) + ISNULL([Installing update(s)], 0) + ISNULL([Waiting for another installation to complete], 0) + ISNULL([Pending system restart], 0) + ISNULL([Downloading update(s)], 0)))*100) as Numeric(10,2)) as varchar(256)) + ‘%’ AS ‘% Compliant’,

  [Compliant],

  [Enforcement state unknown],

  [Successfully installed update(s)],

  [Failed to install update(s)],

  [Installing update(s)],

  [Waiting for another installation to complete],

  [Pending system restart],

  [Downloading update(s)]

From

(select

a.AssignmentName as DeploymentName,

a.StartTime as Available,

a.EnforcementDeadline as Deadline,

sn.StateName as LastEnforcementState,

count(*) as NumberOfComputers

from v_CIAssignment a

join v_AssignmentState_Combined assc

on a.AssignmentID=assc.AssignmentID

join v_StateNames sn

on assc.StateType = sn.TopicType and sn.StateID=isnull(assc.StateID,0)

group by a.AssignmentName, a.StartTime, a.EnforcementDeadline,

      sn.StateName) as PivotData

PIVOT

(

SUM (NumberOfComputers)

FOR LastEnforcementState IN

( [Compliant],

  [Enforcement state unknown],

  [Successfully installed update(s)],

  [Failed to install update(s)],

  [Installing update(s)],

  [Waiting for another installation to complete],

  [Pending system restart],

  [Downloading update(s)])

) AS pvt

I'm new to the site and new to SCCM. Our current environment has File and Print sharing off and SNMP disabled on all client laptops. I have been able to install the SCCM client via script but have no luck on using client push. Is there a way around getting Client push to work without File and Print Sharing? Thank you very much.

On another note; I also notice that only 10% of my clients are reporting status for Security Updates and the rest are under "Unknown". Are these related?