You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
Turn on Animations
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Browse
Tab 1 of 3.
List Tools
Items
List Tools group. Tab 2 of 3.
List
List Tools group. Tab 3 of 3.
Follow
VA DSA SharePoint Portal
Currently selected
Content and Structure Reports
Use the reports list to customize the queries that appear in the Content and Structure Tool views
It looks like your browser does not have JavaScript enabled. Please turn on JavaScript and try again.
Sign In
Home Page
Currently selected
SharePoint Training & Help
Google G Suite Resources
DRS Services
Site Contents
Recent
WWRC FAQ
Exit classic experience
Report Title
CAML Query
Target Audiences
Report Description
Checked Out To Me
<Where><Eq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>
All documents and pages checked out to me in this site and subsites
Last Modified By Me
<Where><Eq><FieldRef Name="Editor" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>
All documents and pages last modified by me in this site and subsites
Pending Approval
<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">2</Value></Eq></Where>
All documents and pages submitted by me and waiting for approval in this site and subsites
My Tasks
<Where><Or><Eq><FieldRef Name="AssignedTo" LookupId="TRUE"/><Value Type="Integer"><UserID /></Value></Eq><Membership Type="CurrentUserGroups"><FieldRef Name="AssignedTo"/></Membership></Or></Where><OrderBy><FieldRef Name="DueDate"/></OrderBy>
All tasks assigned to me in this site and subsites
All Draft Documents
<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">3</Value></Eq></Where>
All documents and pages not yet published in this site and subsites
Going Live Within Next Seven Days
<Where><And><Leq><FieldRef ID="{51d39414-03dc-4bd0-b777-d3e20cb350f7}"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef ID="{51d39414-03dc-4bd0-b777-d3e20cb350f7}"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>
All documents and pages that will be published and visible to readers within the next seven days in this site and subsites
Expiring Within Next Seven Days
<Where><And><Leq><FieldRef ID="{a990e64f-faa3-49c1-aafa-885fda79de62}"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef ID="{a990e64f-faa3-49c1-aafa-885fda79de62}"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>
All documents and pages that will only be visible to authorized users within the next seven days in this site and subsites
Checked Out To Me
<Where><Eq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>
All documents and pages checked out to me in this site and subsites
Last Modified By Me
<Where><Eq><FieldRef Name="Editor" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>
All documents and pages last modified by me in this site and subsites
My Tasks
<Where><Or><Eq><FieldRef Name="AssignedTo" LookupId="TRUE"/><Value Type="Integer"><UserID /></Value></Eq><Membership Type="CurrentUserGroups"><FieldRef Name="AssignedTo"/></Membership></Or></Where><OrderBy><FieldRef Name="DueDate"/></OrderBy>
All tasks assigned to me in this site and subsites
Pending Approval
<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">2</Value></Eq></Where>
All documents and pages submitted by me and waiting for approval in this site and subsites
All Draft Documents
<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">3</Value></Eq></Where>
All documents and pages not yet published in this site and subsites
Going Live Within Next Seven Days
<Where><And><Leq><FieldRef ID="{51d39414-03dc-4bd0-b777-d3e20cb350f7}"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef ID="{51d39414-03dc-4bd0-b777-d3e20cb350f7}"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>
All documents and pages that will be published and visible to readers within the next seven days in this site and subsites
Expiring Within Next Seven Days
<Where><And><Leq><FieldRef ID="{a990e64f-faa3-49c1-aafa-885fda79de62}"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef ID="{a990e64f-faa3-49c1-aafa-885fda79de62}"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>
All documents and pages that will only be visible to authorized users within the next seven days in this site and subsites
Going Live Within Next Seven Days
<Where><And><Leq><FieldRef ID="{51d39414-03dc-4bd0-b777-d3e20cb350f7}"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef ID="{51d39414-03dc-4bd0-b777-d3e20cb350f7}"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>
All documents and pages that will be published and visible to readers within the next seven days in this site and subsites
My Tasks
<Where><Or><Eq><FieldRef Name="AssignedTo" LookupId="TRUE"/><Value Type="Integer"><UserID /></Value></Eq><Membership Type="CurrentUserGroups"><FieldRef Name="AssignedTo"/></Membership></Or></Where><OrderBy><FieldRef Name="DueDate"/></OrderBy>
All tasks assigned to me in this site and subsites
Last Modified By Me
<Where><Eq><FieldRef Name="Editor" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>
All documents and pages last modified by me in this site and subsites
Checked Out To Me
<Where><Eq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="Integer"><UserID/></Value></Eq></Where>
All documents and pages checked out to me in this site and subsites
All Draft Documents
<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">3</Value></Eq></Where>
All documents and pages not yet published in this site and subsites
Expiring Within Next Seven Days
<Where><And><Leq><FieldRef ID="{a990e64f-faa3-49c1-aafa-885fda79de62}"></FieldRef><Value Type="DateTime">[Today + 7]</Value></Leq><Geq><FieldRef ID="{a990e64f-faa3-49c1-aafa-885fda79de62}"/><Value Type="DateTime"><Today /></Value></Geq></And></Where>
All documents and pages that will only be visible to authorized users within the next seven days in this site and subsites
Pending Approval
<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">2</Value></Eq></Where>
All documents and pages submitted by me and waiting for approval in this site and subsites
Follow
javascript: SP.SOD.executeFunc('followingcommon.js', 'FollowDoc', function() { FollowDoc('{ListId}', {ItemId}); });
0x0
0x0
ContentType
0x01
1100
Edit in Dashboard Designer
/_layouts/15/images/ppsEditDesigner.png?rev=43
/_layouts/15/ppswebparts/DesignerRedirect.aspx?Operation=OpenItem&ItemLocation={ItemUrl}
0x0
0x0
ContentType
0x0101004C06BE72B56941358D9BD0B31603EC4D
230
Edit in Dashboard Designer
/_layouts/15/images/PPSSiteTemplateRun.png?rev=43
{SiteUrl}/_layouts/15/ppswebparts/DesignerRedirect.aspx?Operation=OpenItem&ItemLocation={ItemUrl}&ItemType=Dashboard
0x0
0x0
ContentType
0x01002DDC53CB1D5F4520BE0568558051291F06
230
Edit in Dashboard Designer
/_layouts/15/images/PPSSiteTemplateRun.png?rev=43
{SiteUrl}/_layouts/15/ppswebparts/DesignerRedirect.aspx?Operation=OpenItem&ItemLocation={ItemUrl}&ItemType=Filter
0x0
0x0
ContentType
0x01002DDC53CB1D5F4520BE0568558051291F05
230
Edit in Dashboard Designer
/_layouts/15/images/PPSSiteTemplateRun.png?rev=43
{SiteUrl}/_layouts/15/ppswebparts/DesignerRedirect.aspx?Operation=OpenItem&ItemLocation={ItemUrl}&ItemType=Indicator
0x0
0x0
ContentType
0x01002DDC53CB1D5F4520BE0568558051291F03
230
Edit in Dashboard Designer
/_layouts/15/images/PPSSiteTemplateRun.png?rev=43
{SiteUrl}/_layouts/15/ppswebparts/DesignerRedirect.aspx?Operation=OpenItem&ItemLocation={ItemUrl}&ItemType=Kpi
0x0
0x0
ContentType
0x01002DDC53CB1D5F4520BE0568558051291F01
230
Display Report
/_layouts/15/images/PPSSiteTemplateRun.png?rev=43
javascript:window.open('{SiteUrl}/_layouts/15/ppswebparts/ReportViewPreview.aspx?SiteLocation={SiteUrl}&ItemLocation={ItemUrl}')
0x0
0x0
ContentType
0x01002DDC53CB1D5F4520BE0568558051291F04
231
Edit in Dashboard Designer
/_layouts/15/images/ppsEditDesigner.png?rev=43
{SiteUrl}/_layouts/15/ppswebparts/DesignerRedirect.aspx?Operation=OpenItem&ItemLocation={ItemUrl}&ItemType=ReportView
0x0
0x0
ContentType
0x01002DDC53CB1D5F4520BE0568558051291F04
230
Display Scorecard
/_layouts/15/images/PPSSiteTemplateRun.png?rev=43
javascript:window.open('{SiteUrl}/_layouts/15/ppswebparts/ScorecardPreview.aspx?SiteLocation={SiteUrl}&ItemLocation={ItemUrl}')
0x0
0x0
ContentType
0x01002DDC53CB1D5F4520BE0568558051291F02
231
Edit in Dashboard Designer
/_layouts/15/images/ppsEditDesigner.png?rev=43
{SiteUrl}/_layouts/15/ppswebparts/DesignerRedirect.aspx?Operation=OpenItem&ItemLocation={ItemUrl}&ItemType=Scorecard
0x0
0x0
ContentType
0x01002DDC53CB1D5F4520BE0568558051291F02
230
Compliance Details
javascript:if (typeof CalloutManager !== 'undefined' && Boolean(CalloutManager) && Boolean(CalloutManager.closeAll)) CalloutManager.closeAll(); commonShowModalDialog('{SiteUrl}'+ '/_layouts/15/itemexpiration.aspx' +'?ID={ItemId}&List={ListId}', 'center:1;dialogHeight:500px;dialogWidth:500px;resizable:yes;status:no;location:no;menubar:no;help:no', function GotoPageAfterClose(pageid){if(pageid == 'hold') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+ '/_layouts/15/hold.aspx' +'?ID={ItemId}&List={ListId}'); return false;} if(pageid == 'audit') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+ '/_layouts/15/Reporting.aspx' +'?Category=Auditing&backtype=item&ID={ItemId}&List={ListId}'); return false;} if(pageid == 'config') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+ '/_layouts/15/expirationconfig.aspx' +'?ID={ItemId}&List={ListId}'); return false;} if(pageid == 'tag') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+ '/_layouts/15/Hold.aspx' +'?Tag=true&ID={ItemId}&List={ListId}'); return false;}}, null);
0x0
0x1
ContentType
0x01
898
Document Set Version History
/_layouts/15/images/versions.gif?rev=43
javascript:SP.UI.ModalDialog.ShowPopupDialog('{SiteUrl}'+ '/_layouts/15/DocSetVersions.aspx' + '?List={ListId}&ID={ItemId}')
0x0
0x0
ContentType
0x0120D520
330
Send To other location
/_layouts/15/images/sendOtherLoc.gif?rev=43
javascript:GoToPage('{SiteUrl}' + '/_layouts/15/docsetsend.aspx' + '?List={ListId}&ID={ItemId}')
0x0
0x0
ContentType
0x0120D520
350