For a specific Advertisement status for last 3 Days…

---for a specific Advertisement status for last 3 Days… if we include the Set   @AdvName = '%' line then and remove the above line in red color will show for all advertisements with last 3 days status

-- To include all we need to give % in SQL this is a tip

Declare     @AdvName Varchar(256)
Set   @AdvName = 'Lync_2010_Full_Install'

---Set   @AdvName = '%'  
Select      adv.AdvertisementName
,    adv.AdvertisementID
,    s.Host
,    LastAcceptanceMessageIDName
,    LastAcceptanceStateName
,    LastAcceptanceStatusTime
,    LastStatusMessageIDName
,    LastStateName
,    LastStatusTime
,    LastExecutionResult
From  (
      Select      AdvertisementName
      ,    AdvertisementID
      From  dbo.v_AdvertisementInfo
      Where AdvertisementName Like @AdvName
      ) As  adv
Join  (
      Select      AdvertisementID
      ,    ResourceID
      ,    LastAcceptanceMessageIDName
      ,    LastAcceptanceStateName
      ,    LastAcceptanceStatusTime
      ,    LastStatusMessageIDName
      ,    LastStateName
      ,    LastStatusTime
      ,    LastExecutionResult
      From  dbo.v_ClientAdvertisementStatus
      Where LastStatusTime >= DateAdd(d,-3,GetDate())
      ) As  cas
On    adv.AdvertisementID = cas.AdvertisementID
Join  (
      Select      ResourceID
      ,    Netbios_Name0 As Host
      From  dbo.v_R_System
      Where Client0 = 1
      And  Active0 = 1
      And  Obsolete0 = 0   
      ) As  s
On    cas.ResourceID = s.ResourceID
Order By
      AdvertisementName
,    Host

HeartBeat Discovery Status of specific collection of systems

select
    CS.Name0,
    max(AD.AgentTime) as 'Date/Time'
from
    dbo.v_AgentDiscoveries ad
    JOIN dbo.v_GS_COMPUTER_SYSTEM cs on AD.ResourceID = CS.ResourceId
    join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = CS.ResourceId
Where
    AgentName = 'Heartbeat Discovery'
    and FCM.CollectionID = 'SMS00001'
Group by
    CS.Name0

To get ride of IIS Webdav issue

Most of the time some or other application extension would be blocked because of IIS Webdav Settings issue, to stop filtering in IIS Webdav we can change the

setting at the site level, i.e., open inetmgr/ IIS Console and chose the server name and in the right side we need to choose the “WebDav Authoring Rules” and in actions you will see “WebDAV  settings” click on the  button and you need to configure you Request filtering Behavior as below.

 

 

Okey, we may read in the blogs as we need to change in the applicationHost.config file.. if we do above settings it must be appear in the file… okey if you want to see the file how it looks like ……..

<requestFiltering>

                <fileExtensions allowUnlisted="true" applyToWebDAV="false">

                    <add fileExtension=".asa" allowed="true" />

                    <add fileExtension=".asax" allowed="true" />

                    <add fileExtension=".ascx" allowed="true" />

                    <add fileExtension=".master" allowed="true" />

                    <add fileExtension=".skin" allowed="true" />

                    <add fileExtension=".browser" allowed="true" />

                    <add fileExtension=".sitemap" allowed="true" />

                    <add fileExtension=".config" allowed="true" />

                    <add fileExtension=".cs" allowed="true" />

                    <add fileExtension=".csproj" allowed="true" />

                    <add fileExtension=".vb" allowed="true" />

                    <add fileExtension=".vbproj" allowed="true" />

                    <add fileExtension=".webinfo" allowed="true" />

                    <add fileExtension=".licx" allowed="true" />

                    <add fileExtension=".resx" allowed="true" />

                    <add fileExtension=".resources" allowed="true" />

                    <add fileExtension=".mdb" allowed="true" />

                    <add fileExtension=".vjsproj" allowed="true" />

                    <add fileExtension=".java" allowed="true" />

                    <add fileExtension=".jsl" allowed="true" />

                    <add fileExtension=".ldb" allowed="true" />

                    <add fileExtension=".dsdgm" allowed="true" />

                    <add fileExtension=".ssdgm" allowed="true" />

                    <add fileExtension=".lsad" allowed="true" />

                    <add fileExtension=".ssmap" allowed="true" />

                    <add fileExtension=".cd" allowed="true" />

                    <add fileExtension=".dsprototype" allowed="true" />

                    <add fileExtension=".lsaprototype" allowed="true" />

                    <add fileExtension=".sdm" allowed="true" />

                    <add fileExtension=".sdmDocument" allowed="true" />

                    <add fileExtension=".mdf" allowed="true" />

                    <add fileExtension=".ldf" allowed="true" />

                    <add fileExtension=".ad" allowed="true" />

                    <add fileExtension=".dd" allowed="true" />

                    <add fileExtension=".ldd" allowed="true" />

                    <add fileExtension=".sd" allowed="true" />

                    <add fileExtension=".adprototype" allowed="true" />

                    <add fileExtension=".lddprototype" allowed="true" />

                    <add fileExtension=".exclude" allowed="true" />

                    <add fileExtension=".refresh" allowed="true" />

                    <add fileExtension=".compiled" allowed="true" />

                    <add fileExtension=".msgx" allowed="true" />

                    <add fileExtension=".vsdisco" allowed="true" />

                    <add fileExtension=".exe" allowed="true" />

                    <add fileExtension=".vbs" allowed="true" />

                </fileExtensions>

                <verbs allowUnlisted="true" applyToWebDAV="false" />

                <hiddenSegments applyToWebDAV="false">

                    <add segment="web.config" />

                    <add segment="bin" />

                    <add segment="App_code" />

                    <add segment="App_GlobalResources" />

                    <add segment="App_LocalResources" />

                    <add segment="App_WebReferences" />

                    <add segment="App_Data" />

                    <add segment="App_Browsers" />

                </hiddenSegments>

            </requestFiltering>

PXE error: PXE-T01:File not Found & PXE-E3B: TFTP Error – File Not Found

 

You might get the below error..

 

 

The above problem will come When you don’t Have the files in DriveLetter:\RemoteInstall\SMSBoot\  

In fact the below article address the issue, However I have approached in different way as just copy the Missing files & folders from other Remote Install Folder and past on the Problem system.

 

http://www.kozeniauskas.com/itblog/2008/02/26/sccm-pxe-t01-file-not-found-and-pxee3b-tftp-error-file-not-found-errors/