Sorry - "kleiner Autounfall" hat mich rausgehauen...
Aktueller Status ist der hier (den hab ich als View eingebunden) damit ich ihn einfacher von Tools abfragen kann:
SELECT TOP (100) PERCENT u.UpdateID, u.LocalUpdateID, r.RevisionID,
(SELECT TOP (1) FileDigest
FROM dbo.tbFileForRevision
WHERE (RevisionID = r.RevisionID)) AS FileDigest,
(SELECT TOP (1) dbo.tbFile.FileName
FROM dbo.tbFile INNER JOIN
dbo.tbFileForRevision AS tbFileForRevision_4 ON dbo.tbFile.FileDigest = tbFileForRevision_4.FileDigest
WHERE (dbo.tbFile.FileDigest IN
(SELECT FileDigest
FROM dbo.tbFileForRevision AS tbFileForRevision_3
WHERE (RevisionID = r.RevisionID)))) AS FileName,
(SELECT TOP (1) tbFile_1.MUURL
FROM dbo.tbFile AS tbFile_1 INNER JOIN
dbo.tbFileForRevision AS tbFileForRevision_2 ON tbFile_1.FileDigest = tbFileForRevision_2.FileDigest
WHERE (tbFile_1.FileDigest IN
(SELECT FileDigest
FROM dbo.tbFileForRevision AS tbFileForRevision_1
WHERE (RevisionID = r.RevisionID)))) AS MUURL,
(SELECT TOP (1) LanguageID
FROM dbo.tbRevisionLanguage
WHERE (RevisionID = r.RevisionID)) AS LanguageID,
(SELECT TOP (1) LongLanguage
FROM dbo.tbLanguage
WHERE (LanguageID IN
(SELECT LanguageID
FROM dbo.tbRevisionLanguage AS tbRevisionLanguage_1
WHERE (RevisionID = r.RevisionID)))) AS LongLanguage, lp.Title AS Description, lp.Description AS DefaultDescription,
p.ReceivedFromCreatorService AS ArrivalDate, p.CreationDate, p.MsrcSeverity,
(CASE p.PublicationState WHEN 0 THEN N'Published' WHEN 1 THEN N'Expired' ELSE NULL END) AS PublicationState,
(CASE uc.UpdateID WHEN '5C9376AB-8CE6-464a-B136-22113DD69801' THEN N'SoftwareApplication' ELSE p.UpdateType END) AS UpdateType,
(CASE u.IsLocallyPublished WHEN 0 THEN N'MicrosoftUpdate' ELSE N'Other' END) AS UpdateSource,
(SELECT TOP (1) KBArticleID
FROM dbo.tbKBArticleForRevision
WHERE (RevisionID = r.RevisionID)
ORDER BY KBArticleID DESC) AS KnowledgebaseArticle,
(SELECT TOP (1) SecurityBulletinID
FROM dbo.tbSecurityBulletinForRevision
WHERE (RevisionID = r.RevisionID)
ORDER BY SecurityBulletinID DESC) AS SecurityBulletin, ISNULL(p.InstallRequiresUserInput, 0) AS InstallationCanRequestUserInput,
ISNULL(p.InstallRequiresConnectivity, 0) AS InstallationRequiresNetworkConnectivity,
(CASE p.InstallationImpact WHEN 0 THEN N'Normal' WHEN 1 THEN N'Minor' WHEN 2 THEN N'RequiresExclusiveHandling' ELSE N'Normal' END)
AS InstallationImpact,
(CASE p.InstallRebootBehavior WHEN 0 THEN N'NeverReboots' WHEN 1 THEN N'AlwaysRequiresReboot' WHEN 2 THEN N'CanRequestReboot' ELSE N'NeverReboots'
END) AS InstallationRebootBehavior
FROM dbo.tbUpdate AS u INNER JOIN
dbo.tbRevision AS r ON u.LocalUpdateID = r.LocalUpdateID INNER JOIN
dbo.tbProperty AS p ON r.RevisionID = p.RevisionID INNER JOIN
dbo.tbRevisionInCategory AS rc ON rc.RevisionID = r.RevisionID AND rc.Expanded = 0 INNER JOIN
dbo.tbUpdate AS uc ON uc.LocalUpdateID = rc.CategoryID INNER JOIN
dbo.tbCategory AS c ON uc.LocalUpdateID = c.CategoryID AND c.CategoryType = N'UpdateClassification' INNER JOIN
dbo.tbLocalizedPropertyForRevision AS lpr ON lpr.RevisionID = r.RevisionID AND lpr.LanguageID = p.DefaultPropertiesLanguageID INNER JOIN
dbo.tbLocalizedProperty AS lp ON lp.LocalizedPropertyID = lpr.LocalizedPropertyID
WHERE (r.IsLatestRevision = 1) AND (p.ExplicitlyDeployable = 1)
ORDER BY ArrivalDate
Nun merke ich allerdings, dass ich alle möglichen Daten bekomme, jedoch die großen SP's und der ganze Spaß.... Also das Wichtigste!
Da scheine ich nur die Eula zu bekommen...
Andererseits: Was muss ich machen, damit der WSUS die SP's statt der Eula in der DB hat?
Irgdendwie scheint der Wurm drin zu sein...