Sometimes we need to know when last time a plugin was updated. This information is helpful usually before exporting assemblies from one environment to other.
In similar way few times we may need to know who updated a particular assembly last time ?
The following LINQ or Fetch Xml query will return this summary:
(from p in PluginAssemblySet
orderby p.ModifiedOn descending
select new
{
PluginName = p.Name, ModifiedOn = p.ModifiedOn.Value.ToLocalTime(),
ModifiedBy= p.ModifiedBy.Name, Role=p.ModifiedBy.LogicalName,Version=p.Version
}).Dump();
<fetch distinct=”false” no-lock=”false” mapping=”logical” >
<entity name=”pluginassembly” >
<attribute name=”name” />
<attribute name=”modifiedon” />
<attribute name=”modifiedby” />
<attribute name=”version” />
<order attribute=”modifiedon” descending=”true” />
</entity>
</fetch>
*This post is locked for comments