Wednesday, February 8, 2012

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
,    Host

HeartBeat Discovery Status of specific collection of systems

    max(AD.AgentTime) as 'Date/Time'
    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
    AgentName = 'Heartbeat Discovery'
    and FCM.CollectionID = 'SMS00001'
Group by

Tuesday, February 7, 2012

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 ……..


                <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" />


                <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" />



Monday, February 6, 2012

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.