SELECT DISTINCT
app.Manufacturer, app.DisplayName,
app.SoftwareVersion, dt.DisplayName AS DeploymentTypeName,
dt.PriorityInLatestApp, dt.Technology,
dbo.v_ContentInfo.ContentSource,
dbo.v_ContentInfo.SourceSize
FROM dbo.fn_ListDeploymentTypeCIs(1033) AS dt INNER JOIN
dbo.fn_ListLatestApplicationCIs(1033) AS app ON
dt.AppModelName = app.ModelName LEFT OUTER JOIN
dbo.v_ContentInfo ON dt.ContentId =
dbo.v_ContentInfo.Content_UniqueID
WHERE (dt.IsLatest = 1)
Taken from:
http://anoopcnair.com/2012/05/07/configmgr-sccm-2012-custom-reports-for-list-of-applications-deployment-types-and-content-source/
From: [email protected] [mailto:[email protected]] On
Behalf Of Corkill, Daniel
Sent: Monday, October 19, 2015 4:07 PM
To: [email protected]
Subject: [mssms] RE: Detailing data source for all packages
Thanks. That returned a bunch of packages with no source that turned out to be
our applications. Anyway to return all application deployment type data sources?
Daniel.
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Daniel Ratliff
Sent: Thursday, 15 October 2015 10:01 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] RE: Detailing data source for all packages
Here is the SQL, not sure about #2. I always Update DPs to be safe.
select PackageID, Manufacturer, Name, Version, PkgSourcePath
from v_package
Daniel Ratliff
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Corkill, Daniel
Sent: Wednesday, October 14, 2015 10:04 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] Detailing data source for all packages
I've stumbled upon a couple packages this morning that are referring to source
locations on an old server. So a couple questions:
1. Anyone have an SQL query or other way to list all packages and their
data source so I can see if there's any others
2. Just confirming I understand how to change the source correctly: copy
the source to the new location, change the package's source to the new
location, ConfigMgr will update the content on DPs
Daniel.
*********************************************************************
This email, including any attachment, is confidential to the intended
recipient. It may also be privileged and may be subject to copyright. If you
have received this email in error, please notify the sender immediately and
delete all copies of the email. Any confidentiality or privilege is not
waived. Neither the Council nor the sender warrant that this email does not
contain any viruses or other unsolicited items.
This email is an informal Council communication. The Council only accepts
responsibility for information sent under official letterhead and duly signed
by, or on behalf of, the Chief Executive Officer.
Privacy Collection Notice
Logan City Council may collect your personal information, e.g. name,
residential address, phone number etc, in order to conduct its business and/or
meet its statutory obligations. The information will only be accessed by
employees and/or Councillors of Logan City Council for Council business related
activities only. If your personal information will be passed onto a third
party, Council will advise you of this disclosure, the purpose of the
disclosure and reason why. Your information will not be given to any other
person or agency unless you have given us permission or we are required by law.
The information transmitted is intended only for the person or entity to which
it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information
in error,
please contact the sender and delete or destroy the material/information.
*********************************************************************
This email, including any attachment, is confidential to the intended
recipient. It may also be privileged and may be subject to copyright. If you
have received this email in error, please notify the sender immediately and
delete all copies of the email. Any confidentiality or privilege is not
waived. Neither the Council nor the sender warrant that this email does not
contain any viruses or other unsolicited items.
This email is an informal Council communication. The Council only accepts
responsibility for information sent under official letterhead and duly signed
by, or on behalf of, the Chief Executive Officer.
Privacy Collection Notice
Logan City Council may collect your personal information, e.g. name,
residential address, phone number etc, in order to conduct its business and/or
meet its statutory obligations. The information will only be accessed by
employees and/or Councillors of Logan City Council for Council business related
activities only. If your personal information will be passed onto a third
party, Council will advise you of this disclosure, the purpose of the
disclosure and reason why. Your information will not be given to any other
person or agency unless you have given us permission or we are required by law.
________________________________
This message is intended for the sole use of the addressee, and may contain
information that is privileged, confidential and exempt from disclosure under
applicable law. If you are not the addressee you are hereby notified that you
may not use, copy, disclose, or distribute to anyone the message or any
information contained in the message. If you have received this message in
error, please immediately advise the sender by reply email and delete this
message.
