private bool doViewReportsWithSubElements(contentManagerService1 cCMS, ref List<CogObject> reports, string cogVersion, string baseReportPath)
{
if (cCMS == null)
{
reports = null;
return false;
}
// Declare query properties array for report
propEnum[] reportProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString, propEnum.creationTime,
propEnum.metadataModelPackage, propEnum.ancestors, propEnum.disabled};
// Declare properties to retrieve for package object internal to report object
refProp packageProps = new refProp();
packageProps.refPropName = propEnum.metadataModelPackage;
packageProps.properties = new propEnum[] { propEnum.searchPath, propEnum.storeID,
propEnum.defaultName, propEnum.disabled,
propEnum.ancestors };
// Declare sort properties for reports and users
//reports
sort[] reportSort = new sort[] { new sort() };
reportSort[0].order = orderEnum.ascending;
reportSort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps= new refProp[] { packageProps };
// Declare search path for reports and for a single user, based on CAMID
searchPathMultipleObject reportsPath = new searchPathMultipleObject();
searchPathMultipleObject userPath = new searchPathMultipleObject();
//Set search paths to get reports. Userpath must be set
//separately for each individual based on CAMID
reportsPath.Value = "/content//report";
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(reportsPath, reportProps, reportSort, qo);
if (bc.Length > 0)
{
foreach (baseClass report_item in bc)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.report report = (cognosdotnet_2_0.report)report_item;
CogObject rpt = new CogObject();
rpt.ID = report_item.storeID.value.Value;
rpt.AddAttribute("ID", rpt.ID);
rpt.AddAttribute("Name", report_item.defaultName.value);
rpt.AddAttribute("CreationTime", report_item.creationTime.value.ToString());
rpt.AddAttribute("Type", "Report");
rpt.AddAttribute("Disabled", report.disabled.value.ToString());
// Make sure package or model is not null
if (report.metadataModelPackage.value!= null)
{
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)report.metadataModelPackage.value[0];
rpt.AddAttribute("Package_Path", report.metadataModelPackage.value[0].searchPath.value);
rpt.AddAttribute("Package_Name", getPackageName(rpt.getAttributeValue("Package_Path")));
rpt.AddAttribute("Package_Disabled", package.disabled.value.ToString());
}
else
{
rpt.AddAttribute("Package_Path", "null");
rpt.AddAttribute("Package_Name", "null");
rpt.AddAttribute("Package_Disabled", "null");
}
// Make sure owner is not null
if (report_item.owner.value != null)
{
getUserAccount(cCMS, report_item.owner.value[0].searchPath.value, ref rpt);
rpt.AddAttribute("Author_CAMID", report_item.owner.value[0].searchPath.value);
}
else
{
rpt.AddAttribute("Author_CAMID", "Unknown");
}
String version = cogVersion;
rpt.AddAttribute("Version", cogVersion);
rpt.AddAttribute("Path", report_item.searchPath.value);
rpt.AddAttribute("URL", baseReportPath + report_item.searchPath.value);
getSubElements(cCMS, report_item.searchPath.value, ref rpt);
/* This gets some limited auditing information. Most of this can be found
* more easily in the Raw Usage report of the Business Intelligence Dashboard
* package on perform-dev.tyson.com. Uncommenting the following line will
* cause a dramatic increase in runtime for this program
*/
//getAuditInfo(ref cog);
reports.Add(rpt);
}
}
else
{
reports = null;
}
return true;
}
public void setPermissionsOnFolders(string userSearchPath, contentManagerService1 cmService, string sPath)
{
searchPathMultipleObject spMulti = new searchPathMultipleObject();
spMulti.Value = sPath;
folder pFolder = (folder)cmService.query(spMulti, new propEnum[]{propEnum.searchPath,propEnum.policies},new sort[]{},new queryOptions())[0];
bool found = false;
permission newPermission = new permission();
newPermission.name ="execute";
newPermission.access = accessEnum.deny;
for (int i = 0; i < pFolder.policies.value.Length && !found; i ++)
{
policy policy = pFolder.policies.value[i];
//If the security object already exists, update its permissions
if(policy.securityObject.searchPath.value.Equals(userSearchPath))
{
found = true;
permission[] newPerms = new permission[policy.permissions.Length + 1];
for(int j = 0; j < policy.permissions.Length; j ++)
{
newPerms[j] = policy.permissions[j];
}
newPerms[newPerms.Length - 1] = newPermission;
policy.permissions = newPerms;
}
}
//If the security object does not exist, create a new one
if(!found)
{
baseClass entry = null;
spMulti.Value = userSearchPath;
entry = cmService.query(spMulti, new propEnum[]{},new sort[]{},new queryOptions())[0];
policy newPolicy = new policy();
newPolicy.securityObject = entry;
permission[] permissions = new permission[1];
permissions[0] = newPermission;
newPolicy.permissions = permissions;
policyArrayProp existingPols = pFolder.policies ;
policy[] newPols = new policy[existingPols.value.Length + 1];
for(int j = 0; j < existingPols.value.Length; j ++)
{
newPols[j] = existingPols.value[j];
}
newPols[newPols.Length - 1] = newPolicy;
existingPols.value = newPols;
}
cmService.update(new baseClass[]{pFolder},new updateOptions() );
}
public void deleteUserFromPermissions(string userSearchPath, contentManagerService1 cmService, string sPath)
{
//set searchPath of the required folder
searchPathMultipleObject spMulti = new searchPathMultipleObject();
spMulti.Value = sPath;
folder pFolder = (folder)cmService.query(spMulti, new propEnum[]{propEnum.searchPath,propEnum.policies},new sort[]{},new queryOptions())[0];
//keep trak if the aecurity object was found in the permissions
bool found = false;
for (int i = 0; i < pFolder.policies.value.Length && !found; i ++)
{
policy policy = pFolder.policies.value[i];
//If the security object already exists, update its permissions
if(policy.securityObject.searchPath.value.Equals(userSearchPath))
{
found = true;
}
}
//if the security object exists, remove it from the array of permissions
if (found)
{
policy[] newPolicies = new policy[pFolder.policies.value.Length-1];
policyArrayProp pArray = new policyArrayProp();
for (int i = 0; i < pFolder.policies.value.Length ; i ++)
{
policy policy = pFolder.policies.value[i];
if(!policy.securityObject.searchPath.value.Equals(userSearchPath))
{
newPolicies[i] = new policy ();
newPolicies[i].securityObject = pFolder.policies.value[i].securityObject;
newPolicies[i].permissions = pFolder.policies.value[i].permissions;
}
}
//If the security object does not exist, nothing to delete
pArray.value = newPolicies;
pFolder.policies = pArray;
cmService.update(new baseClass[]{pFolder},new updateOptions() );
}
}
private bool doViewObjectsByPackage(contentManagerService1 cCMS, ref List<CogObject> packages, string cogVersion, string basePackagePath)
{
if (cCMS == null)
{
packages = null;
return false;
}
// Same query options used for all calls
queryOptions qo = new queryOptions();
//queries
propEnum[] packageProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString,
propEnum.metadataModelPackage, propEnum.policies, propEnum.ancestors};
//queries
sort[] pkgSort = new sort[] { new sort() };
pkgSort[0].order = orderEnum.ascending;
pkgSort[0].propName = propEnum.defaultName;
searchPathMultipleObject packagesPath = new searchPathMultipleObject();
packagesPath.Value = "/content//package";
// Make call to get all queries. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcPackages = cCMS.query(packagesPath, packageProps, pkgSort, qo);
if (bcPackages.Length > 0)
{
foreach (baseClass package_item in bcPackages)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)package_item;
CogObject pkg = new CogObject();
pkg.ID = package_item.storeID.value.Value;
pkg.AddAttribute("ID", pkg.ID);
pkg.AddAttribute("Name", package_item.defaultName.value);
pkg.AddAttribute("Type", "Package");
addSecurityPolicies(ref pkg, package_item);
if (package_item.owner.value != null)
{
getUserAccount(cCMS, package_item.owner.value[0].searchPath.value, ref pkg);
pkg.AddAttribute("Author_CAMID", package_item.owner.value[0].searchPath.value);
}
else
{
pkg.AddAttribute("Author_CAMID", "Unknown");
}
pkg.AddAttribute("Version", cogVersion);
pkg.AddAttribute("URL", basePackagePath + package_item.searchPath.value);
/* Run another query to retrieve all reports for given package based on package path
*/
List<CogObject> children = new List<CogObject>();
getObjectsForPackage(cCMS, ref children, cogVersion, basePackagePath, package_item.searchPath.value +
"//report | " + package_item.searchPath.value + "//query | " +
package_item.searchPath.value + "//reportView");
pkg.addSubElements(children);
packages.Add(pkg);
}
}
else
{
packages = null;
}
return true;
}
/**
* Method to take in a list of paths to cognos objects and disable them.
* pwnsauce...
*/
public void disableCogObjects()
{
System.IO.TextReader reader = new StreamReader("objectsToDisable.txt");
StreamWriter errorWriter = new StreamWriter("objectsNotFoundC8.txt");
StreamWriter successWriter = new StreamWriter("objectsFoundC8.txt");
// Declare query properties array for report
propEnum[] props = new propEnum[] { propEnum.defaultName, propEnum.disabled,
propEnum.searchPath};
// Declare sort properties for reports and users
//reports
sort[] sorts = new sort[] { };
// Object representing path to single report
searchPathMultipleObject reportSearchPath = new searchPathMultipleObject();
// Query options
queryOptions qo = new queryOptions();
// Read in first path
string path = reader.ReadLine();
List<baseClass> objectsToDisable = new List<baseClass>();
// Loop through all the paths and generate a list of objects
// to disable
while (path != null)
{
reportSearchPath.Value = path;
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
try
{
baseClass[] bc = cCMS.query(reportSearchPath, props, sorts, qo);
if (bc.Length > 0)
{
booleanProp bp = new booleanProp();
bp.value = true;
bc[0].disabled = bp;
// Add the object to our List of things to disable
objectsToDisable.Add(bc[0]);
successWriter.WriteLine(path);
}
else
{
errorWriter.WriteLine(path);
}
}
// The exception will simply say "The client did something wrong"
// if the path line from the file is nothing resembling a path in the current
// cognos environment
catch (Exception e)
{
errorWriter.WriteLine(path);
}
path = reader.ReadLine();
}
reader.Close();
errorWriter.Close();
successWriter.Close();
updateOptions updateOptions = new updateOptions();
cCMS.update(objectsToDisable.ToArray(), updateOptions);
}
public List<CogObject> getGroupsAndRoles()
{
propEnum[] props = new propEnum[] { propEnum.defaultName, propEnum.searchPath, propEnum.type, propEnum.members,
propEnum.objectClass };
// Properties used to get account class information for the members
refProp memberProps = new refProp();
memberProps.refPropName = propEnum.members;
memberProps.properties = new propEnum[] { propEnum.searchPath, propEnum.defaultName, propEnum.userName,
propEnum.objectClass };
baseClass[] securityObjects = new baseClass[]{};
searchPathMultipleObject spMulti = new searchPathMultipleObject();
account[] targetAccount = null;
List<CogObject> cogObjects = new List<CogObject>();
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { memberProps };
// Set search path to pull back all groups and roles in Cognos
spMulti.Value = "CAMID(\"ADS:f:ou=enterprise reporting,ou=applications,ou=tyson groups\")//group | //group | //role";
Console.WriteLine(spMulti.Value);
// Query for all groups and roles
try
{
securityObjects = cCMS.query(spMulti, props, new sort[] { }, qo);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
if (securityObjects.Length <= 0)
{
Console.WriteLine("No roles or groups were found.");
}
// Loop through groups and roles and get members for each
foreach (baseClass securityObject in securityObjects)
{
baseClass[] members = new baseClass[] { };
searchPathMultipleObject membersPath = new searchPathMultipleObject();
membersPath.Value = "expandMembers(" + securityObject.searchPath.value + ")";
// Attempt to get members for the group or role
try
{
members = cCMS.query(membersPath, props, new sort[] { }, new queryOptions());
// Loop through members of the group
foreach (account account in members)
{
CogObject user = new CogObject();
user.AddAttribute("user", account.defaultName.value);
if (securityObject is role)
{
user.AddAttribute("categoryType", "role");
}
else if (securityObject is group)
{
user.AddAttribute("categoryType", "group");
}
else
{
user.AddAttribute("categoryType", "unknown");
}
user.AddAttribute("categoryName", securityObject.defaultName.value);
cogObjects.Add(user);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
return cogObjects;
}
private bool turnOffReportViewDuration(int[] cellCount)
{
Microsoft.Office.Interop.Excel.Application oXL = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook oWB;
Microsoft.Office.Interop.Excel._Worksheet oSheet;
Microsoft.Office.Interop.Excel.Range oRange;
// Create Excel Application
oXL.Visible = true;
//Get a new workbook.
oWB = (Microsoft.Office.Interop.Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
oSheet = (Microsoft.Office.Interop.Excel._Worksheet)oWB.ActiveSheet;
if (cCMS == null)
{
return false;
}
// Declare query properties array for report
propEnum[] reportProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.retentions, propEnum.owner };
// Properties used to get account class information for the owner
refProp ownerProps = new refProp();
ownerProps.refPropName = propEnum.owner;
ownerProps.properties = new propEnum[] { propEnum.searchPath, propEnum.defaultName };
// Declare sort properties for reports and users
//reports
sort[] reportSort = new sort[] { new sort() };
reportSort[0].order = orderEnum.ascending;
reportSort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { ownerProps };
// Declare search path for reports and for a single user, based on CAMID
searchPathMultipleObject objectsPath = new searchPathMultipleObject();
searchPathMultipleObject userPath = new searchPathMultipleObject();
//Set search paths to get reports. Userpath must be set
//separately for each individual based on CAMID
objectsPath.Value = "//reportView";
//objectsPath.Value = "/content/package[@name='National Accounts']/report[@name='(0226) NA Ebit by Customer/Minor Line - Combined']";
//objectsPath.Value = "CAMID(\"ADS:u:cn=miller\\, barret,ou=new,ou=groups,ou=general,ou=tyson team members\")/folder[@name='My Folders']/reportView[@name='Report View of (0224) Combined Sales']";
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(objectsPath, reportProps, reportSort, qo);
retentionRuleArrayProp retentionRules = new retentionRuleArrayProp();
retentionRule[] outputRule = new retentionRule[1];
outputRule[0] = new retentionRule();
outputRule[0].objectClass = classEnum.reportVersion;
outputRule[0].prop = propEnum.creationTime;
outputRule[0].maxDuration = null;
//outputRule[0].maxObjects = "1";
retentionRules.value = outputRule;
List<baseClass> turnOffDurationList = new List<baseClass>();
if (bc.Length > 0)
{
foreach (baseClass report_item in bc)
{
// Cast base class object to more specific report object for access to more
// properties
if (report_item is reportView)
{
cognosdotnet_2_0.reportView reportv = (cognosdotnet_2_0.reportView)report_item;
foreach (retentionRule rule in reportv.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.searchPath.value;
//Increment the column count
cellCount[1]++;
if (reportv.owner.value == null)
{
oSheet.Cells[cellCount[0], cellCount[1]] = "unknown";
}
else
{
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.owner.value[0].defaultName.value;
}
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
reportv.retentions = retentionRules;
turnOffDurationList.Add(report_item);
}
}
}
}
if (turnOffDurationList.Count > 0)
{
cCMS.update(turnOffDurationList.ToArray(), new updateOptions());
}
}
return true;
}
private bool turnOffMyFolderContentDuration(int[] cellCount)
{
Microsoft.Office.Interop.Excel.Application oXL = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook oWB;
Microsoft.Office.Interop.Excel._Worksheet oSheet;
Microsoft.Office.Interop.Excel.Range oRange;
// Create Excel Application
oXL.Visible = true;
//Get a new workbook.
oWB = (Microsoft.Office.Interop.Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
oSheet = (Microsoft.Office.Interop.Excel._Worksheet)oWB.ActiveSheet;
string camid = "//account"; //this is the search path for all user accounts
//string camid = "CAMID(\"ADS:u:cn=miller\\, barret,ou=new,ou=groups,ou=general,ou=tyson team members\")";
string userSearchPaths = "";
// We will display My Folders and My Pages for all users in namespace
propEnum[] props = new propEnum[]{propEnum.searchPath,
propEnum.objectClass,propEnum.defaultName,propEnum.portalPages,
propEnum.ancestors, propEnum.owner};
// Same query options used for all calls
queryOptions qo = new queryOptions();
// Create sort object
sort[] accountSort = new sort[] { new sort() };
accountSort[0].order = orderEnum.ascending;
accountSort[0].propName = propEnum.defaultName;
//query for all accounts
searchPathMultipleObject spMulti = new searchPathMultipleObject();
spMulti.Value = camid;
baseClass[] bc = cCMS.query(spMulti, props, accountSort, qo);
if (bc != null && bc.Length > 0)
{
// Set different properties to grab for the reports, queries, or report views
props = new propEnum[]{propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString, propEnum.creationTime,
propEnum.metadataModelPackage, propEnum.ancestors, propEnum.disabled, propEnum.user,
propEnum.retentions };
// Declare properties to retrieve for package object internal to report object
refProp packageProps = new refProp();
packageProps.refPropName = propEnum.metadataModelPackage;
packageProps.properties = new propEnum[] { propEnum.searchPath, propEnum.storeID,
propEnum.defaultName, propEnum.disabled,
propEnum.ancestors };
// Properties used to get base class information if the object is a report view
refProp reportProps = new refProp();
reportProps.refPropName = propEnum.@base;
reportProps.properties = new propEnum[] { propEnum.metadataModelPackage, propEnum.storeID,
propEnum.searchPath, propEnum.disabled };
qo.refProps = new refProp[] { packageProps, reportProps };
retentionRuleArrayProp retentionRules = new retentionRuleArrayProp();
retentionRule[] outputRule = new retentionRule[1];
outputRule[0] = new retentionRule();
outputRule[0].objectClass = classEnum.reportVersion;
outputRule[0].prop = propEnum.creationTime;
outputRule[0].maxDuration = null;
//outputRule[0].maxObjects = "1";
List<baseClass> turnOffDurationList = new List<baseClass>();
for (int i = 0; i < bc.Length; i++)
{
//Query the Content Store for all objects in My Folders for user bc[i]
userSearchPaths = bc[i].searchPath.value + "/folder[@name='My Folders']//report"; /*+
bc[i].searchPath.value + "/folder[@name='My Folders']//query |" +
bc[i].searchPath.value + "/folder[@name='My Folders']//reportView";*/
spMulti.Value = userSearchPaths;
baseClass[] contents = cCMS.query(spMulti, props, new sort[] { }, qo);
if (contents != null && contents.Length > 0)
{
//Disable Duration all objects in My Folders for user bc[i]
for (int j = 0; j < contents.Length; j++)
{
/*
* Check whether object is a more specific type (e.g. query or report)
*/
if (contents[j] is report)
{
cognosdotnet_2_0.report report = (cognosdotnet_2_0.report)contents[j];
foreach (retentionRule rule in report.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = report.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = report.searchPath.value;
//Increment the column count
cellCount[1]++;
oSheet.Cells[cellCount[0], cellCount[1]] = bc[i].defaultName.value;
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
report.retentions = retentionRules;
turnOffDurationList.Add(contents[j]);
}
}
}
else if (contents[j] is query)
{
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)contents[j];
foreach (retentionRule rule in query.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = query.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = query.searchPath.value;
//Increment the column count
cellCount[1]++;
oSheet.Cells[cellCount[0], cellCount[1]] = bc[i].defaultName.value;
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
query.retentions = retentionRules;
turnOffDurationList.Add(contents[j]);
}
}
}
else if (contents[j] is reportView)
{
cognosdotnet_2_0.reportView reportView = (cognosdotnet_2_0.reportView)contents[j];
foreach (retentionRule rule in reportView.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = reportView.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = reportView.searchPath.value;
//Increment the column count
cellCount[1]++;
oSheet.Cells[cellCount[0], cellCount[1]] = bc[i].defaultName.value;
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
reportView.retentions = retentionRules;
turnOffDurationList.Add(contents[j]);
}
}
}
}
if (turnOffDurationList.Count > 0)
{
cCMS.update(turnOffDurationList.ToArray(), new updateOptions());
}
}
}
}
return true;
}
private bool turnOffAndReport_QueryDuration(ref _Worksheet oSheet, int[] cellCount)
{
if (cCMS == null)
{
return false;
}
// Declare query properties array for report
propEnum[] reportProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.retentions, propEnum.owner };
// Properties used to get account class information for the owner
refProp ownerProps = new refProp();
ownerProps.refPropName = propEnum.owner;
ownerProps.properties = new propEnum[] { propEnum.searchPath, propEnum.defaultName };
// Declare sort properties for reports and users
//reports
sort[] reportSort = new sort[] { new sort() };
reportSort[0].order = orderEnum.ascending;
reportSort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { ownerProps };
// Declare search path for reports and for a single user, based on CAMID
searchPathMultipleObject objectsPath = new searchPathMultipleObject();
searchPathMultipleObject userPath = new searchPathMultipleObject();
//Set search paths to get reports. Userpath must be set
//separately for each individual based on CAMID
objectsPath.Value = "//query";
//objectsPath.Value = "/content/package[@name='National Accounts']/report[@name='(0226) NA Ebit by Customer/Minor Line - Combined']";
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(objectsPath, reportProps, reportSort, qo);
retentionRuleArrayProp retentionRules = new retentionRuleArrayProp();
retentionRule[] outputRule = new retentionRule[1];
outputRule[0] = new retentionRule();
outputRule[0].objectClass = classEnum.reportVersion;
outputRule[0].prop = propEnum.creationTime;
outputRule[0].maxDuration = null;
//outputRule[0].maxObjects = "1";
List<baseClass> turnOffDurationList = new List<baseClass>();
if (bc.Length > 0)
{
foreach (baseClass report_item in bc)
{
retentionRules.value = outputRule;
// Cast base class object to more specific report object for access to more
// properties
if (report_item is query)
{
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)report_item;
foreach (retentionRule rule in query.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = query.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = query.searchPath.value;
//Increment the column count
cellCount[1]++;
if (query.owner.value == null)
{
oSheet.Cells[cellCount[0], cellCount[1]] = "unknown";
}
else
{
oSheet.Cells[cellCount[0], cellCount[1]] = query.owner.value[0].defaultName.value;
}
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
query.retentions = retentionRules;
turnOffDurationList.Add(report_item);
}
}
}
}
if (turnOffDurationList.Count > 0)
{
cCMS.update(turnOffDurationList.ToArray(), new updateOptions());
}
}
return true;
}
/// <summary>
/// Application entry point.
/// </summary>
/// <param name="args">Standard command-line arguments.</param>
public static void Main( string[] args )
{
// Attempt a simple CM query.
string searchPath = "//report";
string userName = "******";
string userPassword = "******";
string userNamespace = "ADS";
char[] arg_separator = { '=' };
foreach( string arg in args )
{
string[] command = arg.Split( arg_separator, 2 );
switch( command[0] )
{
case "--search":
searchPath = command[1];
break;
case "--uid":
userName = command[1];
break;
case "--pwd":
userPassword = command[1];
break;
case "--namespace":
userNamespace = command[1];
break;
default:
throw new ApplicationException( "Unknown argument: " + arg );
}
}
// Concatenate the read filter to the searchPath this way we
// ask CM to only return the objects we have read acces on.
//searchPath = searchPath + "[permission('read')]";
// Create the ReportNet connection object.
Console.WriteLine( "Creating CognosReportNetService..." );
contentManagerService1 cmService = new contentManagerService1();
cmService.Url = "http://cogpbi1.tyson.com:9300/p2pd/servlet/dispatch";
//logon to Cognos 8
logon(cmService, userName, userPassword, userNamespace);
propEnum[] props = new propEnum[] { propEnum.searchPath,
propEnum.defaultName, propEnum.policies,
propEnum.permissions, propEnum.members };
sort[] s = new sort[]{ new sort() };
s[0].order = orderEnum.ascending;
s[0].propName = propEnum.defaultName;
queryOptions qo = new queryOptions();
Console.WriteLine( "\nReports:\n" );
// Look for all of the reports.
searchPathMultipleObject spMulti = new searchPathMultipleObject();
spMulti.Value = "/content//package";
//"/content/package[@name='Sales']//report";
baseClass[] bc = null;
try
{
bc = cmService.query(spMulti, props, s, qo );
if( bc.Length > 0 )
{
foreach( baseClass report_item in bc )
{
Console.WriteLine( " {0}", report_item.searchPath.value);
policy[] p = report_item.policies.value;
if (p.Length > 0)
{
foreach( policy pol in p )
{
Console.WriteLine( " {0}", pol.securityObject.searchPath.value);
permission[] perm = pol.permissions;
foreach( permission prm in perm )
Console.WriteLine( " {0} {1}",prm.name, prm.access.ToString());
}
}
}
}
}
catch( System.Web.Services.Protocols.SoapHeaderException ex )
{
displayException(ex);
}
catch( System.Web.Services.Protocols.SoapException ex )
{
displayException(ex);
}
}
private bool getQueriesForPackage(contentManagerService1 cCMS, ref List<CogObject> queries, string cogVersion,
string baseQueryPath, string pathToQueriesInPackage)
{
if (cCMS == null)
{
queries = null;
return false;
}
// Same query options used for all calls
queryOptions qo = new queryOptions();
//queries
propEnum[] queryProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString,
propEnum.metadataModelPackage};
//users
propEnum[] userProps = new propEnum[] { propEnum.userName, propEnum.name, propEnum.user };
//queries
sort[] querySort = new sort[] { new sort() };
querySort[0].order = orderEnum.ascending;
querySort[0].propName = propEnum.defaultName;
//users
sort[] userSort = new sort[] { new sort() };
userSort[0].order = orderEnum.ascending;
userSort[0].propName = propEnum.userName;
searchPathMultipleObject userPath = new searchPathMultipleObject();
searchPathMultipleObject queriesPath = new searchPathMultipleObject();
queriesPath.Value = pathToQueriesInPackage;
// Make call to get all queries. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcQueries = cCMS.query(queriesPath, queryProps, querySort, qo);
if (bcQueries.Length > 0)
{
foreach (baseClass query_item in bcQueries)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)query_item;
CogObject qry = new CogObject();
qry.ID = query_item.storeID.value.Value;
qry.AddAttribute("ID", qry.ID);
qry.AddAttribute("Name", query_item.defaultName.value);
qry.AddAttribute("Type", "AdHoc");
qry.AddAttribute("Package_Path", query.metadataModelPackage.value[0].searchPath.value);
qry.AddAttribute("Package_Name", getPackageName(qry.getAttributeValue("Package_Path")));
if (query_item.owner.value != null)
{
getUserAccount(cCMS, query_item.owner.value[0].searchPath.value, ref qry);
qry.AddAttribute("Author_CAMID", query_item.owner.value[0].searchPath.value);
}
else
{
qry.AddAttribute("Author_CAMID", "Unknown");
}
qry.AddAttribute("Version", cogVersion);
qry.AddAttribute("URL", baseQueryPath + query_item.searchPath.value);
queries.Add(qry);
}
}
else
{
queries = null;
}
return true;
}
private bool getObjectsForPackage(contentManagerService1 cCMS, ref List<CogObject> objects, string cogVersion,
string basePath, string pathToObjectsInPackage)
{
if (cCMS == null)
{
objects = null;
return false;
}
// Declare query properties array for reports, queries and for users
propEnum[] cogProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString,
propEnum.metadataModelPackage, propEnum.user,propEnum.actualExecutionTime,
propEnum.policies};
// Declare sort properties for reports
sort[] cogSort = new sort[] { new sort() };
cogSort[0].order = orderEnum.ascending;
cogSort[0].propName = propEnum.defaultName;
// Same query options used for all calls
queryOptions qo = new queryOptions();
searchPathMultipleObject objectsPath = new searchPathMultipleObject();
// Declare search path for reports and for a single user, based on CAMID
objectsPath.Value = pathToObjectsInPackage;
// Run query to get all objects in package. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(objectsPath, cogProps, cogSort, qo);
if (bc.Length > 0)
{
foreach (baseClass cog_item in bc)
{
CogObject cog = new CogObject();
cog.ID = cog_item.storeID.value.Value;
cog.Name = cog_item.defaultName.value;
cog.AddAttribute("ID", cog.ID);
cog.AddAttribute("Name", cog_item.defaultName.value);
cog.AddAttribute("Version", cogVersion);
cog.AddAttribute("URL", basePath + cog_item.searchPath.value);
addSecurityPolicies(ref cog, cog_item);
/* Get owner/author information for this object
*/
if (cog_item.owner.value != null)
{
getUserAccount(cCMS, cog_item.owner.value[0].searchPath.value, ref cog);
cog.AddAttribute("Author_CAMID", cog_item.owner.value[0].searchPath.value);
}
else
{
cog.AddAttribute("Author_CAMID", "Unknown");
}
/*
* Check whether object is a more specific type (e.g. query or report)
*/
if (cog_item is report)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.report report = (cognosdotnet_2_0.report)cog_item;
cog.AddAttribute("Type", "Report");
// Make sure package or Package is not null
if (report.metadataModelPackage.value != null)
{
cog.AddAttribute("Package_Path", report.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
}
}
else if (cog_item is query)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)cog_item;
cog.AddAttribute("Type", "Query");
// Make sure package or Package is not null
if (query.metadataModelPackage.value != null)
{
cog.AddAttribute("Package_Path", query.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
}
}
else if (cog_item is reportView)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.reportView reportView = (cognosdotnet_2_0.reportView)cog_item;
cog.AddAttribute("Type", "ReportView");
// Make sure package or Package is not null
if (reportView.packageBase != null)
{
cog.AddAttribute("Package_Path", reportView.packageBase.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
}
}
getSubElements(cCMS, cog_item.searchPath.value, ref cog);
// Add the object to the list
objects.Add(cog);
}
}
return true;
}
private bool extractTablesAndFieldsFromModels()
{
bool success = true;
System.IO.StreamWriter writer = new StreamWriter("ModelTablesAndFields.csv");
writer.WriteLine("Model Name|Table Name|Field Name");
// Same query options used for all calls
queryOptions qo = new queryOptions();
propEnum[] packageProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName };
//model sorting
sort[] pkgSort = new sort[] { new sort() };
pkgSort[0].order = orderEnum.ascending;
pkgSort[0].propName = propEnum.defaultName;
searchPathMultipleObject packagePath = new searchPathMultipleObject();
packagePath.Value = "//package";
// Make call to get all queries. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcPackages = cCMS.query(packagePath, packageProps, pkgSort, qo);
foreach (baseClass pkg in bcPackages)
{
//Model properties
propEnum[] modelProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName, propEnum.model };
//model sorting
sort[] mdlSort = new sort[] { new sort() };
mdlSort[0].order = orderEnum.ascending;
mdlSort[0].propName = propEnum.defaultName;
searchPathMultipleObject modelsPath = new searchPathMultipleObject();
modelsPath.Value = pkg.searchPath.value + "/model";
// Make call to get all models. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcmodels = cCMS.query(modelsPath, modelProps, mdlSort, qo);
// Latest model should always be at the end of the array
model latestModel = (model)bcmodels[bcmodels.Length - 1];
/* Uncomment the following code to write a model XML out to file */
if (pkg.defaultName.value == "Commitments")
{
System.IO.StreamWriter xmlWriter = new StreamWriter("model.xml");
xmlWriter.Write(latestModel.model1.value);
xmlWriter.Close();
// Write out the database tables and fields used in the current model
//extractAndWriteTablesAndFields(ref writer, pkg.defaultName.value, latestModel.model1.value);
}
}
writer.Close();
return success;
}
/* Does the bulk of the work to extract information on Users' MyFolder objects
*/
private bool doViewUsersMyFolderContentsWithSubElements(contentManagerService1 cCMS, ref List<CogObject> cogs, string cogVersion, string baseReportPath)
{
string camid = "//account"; //this is the search path for all user accounts
string userSearchPaths = "";
// We will display My Folders and My Pages for all users in namespace
propEnum[] props = new propEnum[]{propEnum.searchPath,
propEnum.objectClass,propEnum.defaultName,propEnum.portalPages,
propEnum.ancestors, propEnum.owner};
// Same query options used for all calls
queryOptions qo = new queryOptions();
// Create sort object
sort[] accountSort = new sort[] { new sort() };
accountSort[0].order = orderEnum.ascending;
accountSort[0].propName = propEnum.defaultName;
//query for all accounts
searchPathMultipleObject spMulti = new searchPathMultipleObject();
spMulti.Value = camid;
baseClass[] bc = cCMS.query(spMulti, props, accountSort, qo);
if (bc != null && bc.Length > 0)
{
// Set different properties to grab for the reports, queries, or report views
props = new propEnum[]{propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString, propEnum.creationTime,
propEnum.metadataModelPackage, propEnum.ancestors, propEnum.disabled};
// Declare properties to retrieve for package object internal to report object
refProp packageProps = new refProp();
packageProps.refPropName = propEnum.metadataModelPackage;
packageProps.properties = new propEnum[] { propEnum.searchPath, propEnum.storeID,
propEnum.defaultName, propEnum.disabled,
propEnum.ancestors };
// Properties used to get base class information if the object is a report view
refProp reportProps = new refProp();
reportProps.refPropName = propEnum.@base;
reportProps.properties = new propEnum[] { propEnum.metadataModelPackage, propEnum.storeID,
propEnum.searchPath, propEnum.disabled };
qo.refProps = new refProp[] { packageProps, reportProps };
for (int i = 0; i < bc.Length; i++)
{
//Query the Content Store for all objects in My Folders for user bc[i]
userSearchPaths = bc[i].searchPath.value + "/folder[@name='My Folders']//report |" +
bc[i].searchPath.value + "/folder[@name='My Folders']//query |" +
bc[i].searchPath.value + "/folder[@name='My Folders']//reportView";
spMulti.Value = userSearchPaths;
baseClass[] contents = cCMS.query(spMulti, props, new sort[] { }, qo);
if (contents != null && contents.Length > 0)
{
//Display all objects in My Folders for user bc[i]
for (int j = 0; j < contents.Length; j++)
{
CogObject cog = new CogObject();
/*
* Check whether object is a more specific type (e.g. query or report)
*/
if (contents[j] is report)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.report report = (cognosdotnet_2_0.report)contents[j];
cog.AddAttribute("Type", "Report");
cog.AddAttribute("CreationTime", contents[j].creationTime.value.ToString());
// Make sure package or Package is not null
if (report.metadataModelPackage.value != null)
{
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)report.metadataModelPackage.value[0];
cog.AddAttribute("Package_Path", report.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
cog.AddAttribute("Package_Disabled", package.disabled.value.ToString());
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
cog.AddAttribute("Package_Disabled", "null");
}
cog.AddAttribute("Disabled", report.disabled.value.ToString());
}
else if (contents[j] is query)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)contents[j];
cog.AddAttribute("Type", "Query");
// Make sure package or Package is not null
if (query.metadataModelPackage.value != null)
{
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)query.metadataModelPackage.value[0];
cog.AddAttribute("Package_Path", query.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
cog.AddAttribute("Package_Disabled", package.disabled.value.ToString());
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
cog.AddAttribute("Package_Disabled", "null");
}
cog.AddAttribute("Disabled", query.disabled.value.ToString());
}
else if (contents[j] is reportView)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.reportView reportView = (cognosdotnet_2_0.reportView)contents[j];
cog.AddAttribute("Type", "ReportView");
// Make sure package or Package is not null
if (reportView.packageBase != null)
{
cog.AddAttribute("Package_Path", reportView.packageBase.value);
cog.AddAttribute("Package_Name", getPackageName(cog.getAttributeValue("Package_Path")));
}
else
{
cog.AddAttribute("Package_Path", "null");
cog.AddAttribute("Package_Name", "null");
}
if ([email protected] != null)
{
cog.AddAttribute("BaseID", [email protected][0].storeID.value.Value);
cog.AddAttribute("BasePath", [email protected][0].searchPath.value);
if ([email protected][0] is report)
{
report tempReport = (report)[email protected][0];
if (tempReport.metadataModelPackage.value[0] != null)
{
cog.AddAttribute("BasePackage_Path", tempReport.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("BasePackage_Name", getPackageName(cog.getAttributeValue("BasePackage_Path")));
}
}
else if ([email protected][0] is query)
{
query tempQuery = (query)[email protected][0];
if (tempQuery.metadataModelPackage.value[0] != null)
{
cog.AddAttribute("BasePackage_Path", tempQuery.metadataModelPackage.value[0].searchPath.value);
cog.AddAttribute("BasePackage_Name", getPackageName(cog.getAttributeValue("BasePackage_Path")));
}
}
cog.AddAttribute("Disabled", reportView.disabled.value.ToString());
}
}
// Make sure owner is not null
if (contents[j].owner.value != null)
{
/* We will get the author based on who's folder the report is in. This may
* not be strictly true. Uncomment the following line to get the old method.
* Also comment out or remove the line farther below that sets the Author_Name
* attribute*/
//getUserAccount(cCMS, contents[j].owner.value[0].searchPath.value, ref cog);
cog.AddAttribute("Author_CAMID", contents[j].owner.value[0].searchPath.value);
}
else
{
cog.AddAttribute("Author_CAMID", "Unknown");
}
cog.AddAttribute("Author_Name", bc[i].defaultName.value);
cog.AddAttribute("Version", cogVersion);
cog.AddAttribute("Name", contents[j].defaultName.value);
cog.AddAttribute("Path", contents[j].searchPath.value);
cog.AddAttribute("URL", baseReportPath + contents[j].searchPath.value);
cog.AddAttribute("MyFolder", "TRUE");
getSubElements(cCMS, contents[j].searchPath.value, ref cog);
/* This gets some limited auditing information. Most of this can be found
* more easily in the Raw Usage report of the Business Intelligence Dashboard
* package on perform-dev.tyson.com. Uncommenting the following line will
* cause a dramatic increase in runtime for this program
*/
//getAuditInfo(ref cog);
cogs.Add(cog);
}
}
}
}
else
{
cogs = null;
}
return true;
}
private bool doViewQueriesWithSubElements(contentManagerService1 cCMS, ref List<CogObject> queries, string cogVersion, string baseQueryPath)
{
if (cCMS == null)
{
queries = null;
return false;
}
//queries
propEnum[] queryProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.owner, propEnum.storeID, propEnum.connectionString, propEnum.creationTime,
propEnum.metadataModelPackage, propEnum.ancestors, propEnum.disabled};
// Declare properties to retrieve for package object internal to report object
refProp packageProps = new refProp();
packageProps.refPropName = propEnum.metadataModelPackage;
packageProps.properties = new propEnum[] { propEnum.searchPath, propEnum.storeID,
propEnum.defaultName, propEnum.disabled,
propEnum.ancestors };
//queries
sort[] querySort = new sort[] { new sort() };
querySort[0].order = orderEnum.ascending;
querySort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { packageProps };
searchPathMultipleObject userPath = new searchPathMultipleObject();
searchPathMultipleObject queriesPath = new searchPathMultipleObject();
queriesPath.Value = "/content//query";
// Make call to get all queries. Get each author for each query during this process
// by making a separate call, based on CAMID; the same as above when pulling the reports.
baseClass[] bcQueries = cCMS.query(queriesPath, queryProps, querySort, qo);
if (bcQueries.Length > 0)
{
foreach (baseClass query_item in bcQueries)
{
// Cast base class object to more specific report object for access to more
// properties
cognosdotnet_2_0.query query = (cognosdotnet_2_0.query)query_item;
CogObject qry = new CogObject();
qry.ID = query_item.storeID.value.Value;
qry.AddAttribute("ID", qry.ID);
qry.AddAttribute("Name", query_item.defaultName.value);
qry.AddAttribute("CreationTime", query_item.creationTime.value.ToString());
qry.AddAttribute("Type", "Query");
qry.AddAttribute("Disabled", query.disabled.value.ToString());
// Make sure package or package is not null
if (query.metadataModelPackage.value != null)
{
cognosdotnet_2_0.package package = (cognosdotnet_2_0.package)query.metadataModelPackage.value[0];
qry.AddAttribute("Package_Path", query.metadataModelPackage.value[0].searchPath.value);
qry.AddAttribute("Package_Name", getPackageName(qry.getAttributeValue("Package_Path")));
qry.AddAttribute("Package_Disabled", package.disabled.value.ToString());
}
else
{
qry.AddAttribute("Package_Path", "null");
qry.AddAttribute("Package_Name", "null");
qry.AddAttribute("Package_Disabled", "null");
}
// Make sure owner is not null
if (query_item.owner.value != null)
{
getUserAccount(cCMS, query_item.owner.value[0].searchPath.value, ref qry);
qry.AddAttribute("Author_CAMID", query_item.owner.value[0].searchPath.value);
}
else
{
qry.AddAttribute("Author_CAMID", "Unknown");
}
qry.AddAttribute("Version", cogVersion);
qry.AddAttribute("Path", query_item.searchPath.value);
qry.AddAttribute("URL", baseQueryPath + query_item.searchPath.value);
getSubElements(cCMS, query_item.searchPath.value, ref qry);
/* This gets some limited auditing information. Most of this can be found
* more easily in the Raw Usage report of the Business Intelligence Dashboard
* package on perform-dev.tyson.com. Uncommenting the following line will
* cause a dramatic increase in runtime for this program
*/
//getAuditInfo(ref cog);
queries.Add(qry);
}
}
else
{
queries = null;
}
return true;
}
private void getSubElements(contentManagerService1 cCMS, string objectSearchPath, ref CogObject cog)
{
searchPathMultipleObject subElementPath = new searchPathMultipleObject();
subElementPath.Value = objectSearchPath + "/*";
// Same query options used for all calls
queryOptions qo = new queryOptions();
//users
propEnum[] subElementProps = new propEnum[] { propEnum.storeID, propEnum.searchPath, propEnum.defaultName,
propEnum.user, propEnum.status, propEnum.requestedExecutionTime,
propEnum.actualExecutionTime, propEnum.actualCompletionTime,
propEnum.eventID, propEnum.ownerEventID, propEnum.asOfTime,
propEnum.canBurst, propEnum.contact, propEnum.contactEMail,
propEnum.metadataModel, propEnum.metadataModelPackage,
propEnum.options, propEnum.parameters, propEnum.runOptions,
propEnum.serverGroup, propEnum.specification, propEnum.active,
propEnum.credential, propEnum.dailyPeriod, propEnum.endDate,
propEnum.endType, propEnum.everyNPeriods, propEnum.startDate,
propEnum.taskID, propEnum.timeZoneID, propEnum.triggerName, propEnum.type,
propEnum.weeklyFriday, propEnum.weeklyMonday, propEnum.weeklySaturday,
propEnum.weeklySunday, propEnum.weeklyThursday, propEnum.weeklyTuesday,
propEnum.weeklyWednesday, propEnum.yearlyAbsoluteDay, propEnum.yearlyAbsoluteMonth,
propEnum.yearlyRelativeDay, propEnum.yearlyRelativeWeek, propEnum.ancestors,
propEnum.creationTime, propEnum.modificationTime, propEnum.name, propEnum.usage,
propEnum.version};
sort[] subElementSort = new sort[] { new sort() };
subElementSort[0].order = orderEnum.ascending;
subElementSort[0].propName = propEnum.defaultName;
baseClass[] bc = cCMS.query(subElementPath, subElementProps, subElementSort, qo);
if (bc.Length > 0)
{
foreach (baseClass item in bc)
{
CogObject cogItem = new CogObject();
if (item is history)
{
cognosdotnet_2_0.history hist = (history)item;
addHistoryAttributes(cogItem, hist);
}
else if (item is schedule)
{
cognosdotnet_2_0.schedule sched = (schedule)item;
cog.AddAttribute("ActiveSchedule", sched.active.value.ToString());
addScheduleAttributes(ref cogItem, sched);
}
else if (item is reportVersion)
{
cognosdotnet_2_0.reportVersion rver = (reportVersion)item;
addReportVersionAttributes(ref cogItem, rver);
}
cog.addSubElement(cogItem);
}
}
}
/* Method to query the content store for the object at the given path and populate the
* referenced object with user name information of the owner or author
*/
private void getUserAccount(contentManagerService1 cCMS, string searchPath, ref CogObject cog)
{
searchPathMultipleObject userPath = new searchPathMultipleObject();
userPath.Value = searchPath;
// Same query options used for all calls
queryOptions qo = new queryOptions();
//users
propEnum[] userProps = new propEnum[] { propEnum.userName, propEnum.name, propEnum.user };
sort[] userSort = new sort[] { new sort() };
userSort[0].order = orderEnum.ascending;
userSort[0].propName = propEnum.userName;
/* Run another query to retrieve the account object based on the CAMID.
UserID is pulled from the account object. CAMID's for users who no
longer work here will return no account objects. Author set to ""
in this case.
*/
baseClass[] bcUserAccount = cCMS.query(userPath, userProps, userSort, qo);
if (bcUserAccount.Length > 0)
{
cognosdotnet_2_0.account account = (cognosdotnet_2_0.account)bcUserAccount[0];
cog.AddAttribute("Author", account.userName.value);
cog.AddAttribute("Author_Name", account.name.value[0].value);
}
else
{
string wholeName = getAuthorName(userPath.Value);
cog.AddAttribute("Author_Name", wholeName);
}
}
public void disableCogObjects(string startDate, int daysBack)
{
List<string> reportPaths = getPathToDisableList(startDate, daysBack);
/* Debugging
List<string> reportPaths = new List<string>();
reportPaths.Add("/content/package[@name='Supply Chain']/folder[@name='Demand']/report[@name='(0014) Product Group Summary'])&ui.name=(0014) Product Group Summary&ui.format=XLS&ui.backURL=/cognos8/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/cc.xts&m_folder=iAB52A69DC50C4C77AC3A623A085EF52A");
*/
List<string> exceptionPaths = getExceptionPathList();
writePathToDisableList(reportPaths);
Console.WriteLine("Please check the file: objectsToDisable.txt in the program executable folder " +
"to make sure everything looks good. Do you want to proceed? Enter 'yes' or 'no' (case insensitive).");
string userChoice = Console.ReadLine();
if(userChoice.ToLower() == "yes")
{
StreamWriter errorWriter = new StreamWriter("objectsNotFoundC8.txt");
StreamWriter successWriter = new StreamWriter("objectsFoundC8.txt");
// Declare query properties array for report
propEnum[] props = new propEnum[] { propEnum.defaultName, propEnum.disabled,
propEnum.searchPath};
// Declare sort properties for reports and users
//reports
sort[] sorts = new sort[] { };
// Object representing path to single report
searchPathMultipleObject reportSearchPath = new searchPathMultipleObject();
// Query options
queryOptions qo = new queryOptions();
List<baseClass> objectsToDisable = new List<baseClass>();
// Loop through all the paths and generate a list of objects
// to disable
for (int i = 0; i < reportPaths.Count; i++)
{
string path = reportPaths[i];
// If the path is not in the exception list, then add it to
// the list of paths to be disabled
if (!checkAgainstExceptions(path, exceptionPaths))
{
reportSearchPath.Value = path;
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
try
{
baseClass[] bc = cCMS.query(reportSearchPath, props, sorts, qo);
if (bc.Length > 0)
{
booleanProp bp = new booleanProp();
bp.value = true;
bc[0].disabled = bp;
// Add the object to our List of things to disable
objectsToDisable.Add(bc[0]);
successWriter.WriteLine(path);
}
else
{
errorWriter.WriteLine(path);
}
}
// The exception will simply say "The client did something wrong"
// if the path line from the file is nothing resembling a path in the current
// cognos environment
catch (Exception e)
{
errorWriter.WriteLine(path);
}
}
}
errorWriter.Close();
successWriter.Close();
updateOptions updateOptions = new updateOptions();
cCMS.update(objectsToDisable.ToArray(), updateOptions);
}
else
{
Console.WriteLine("User entered something other than 'yes'. Aborting...");
}
}
private bool report_ReportViewDuration(ref _Worksheet oSheet, int[] cellCount)
{
if (cCMS == null)
{
return false;
}
// Declare query properties array for report
propEnum[] reportProps = new propEnum[] { propEnum.searchPath, propEnum.defaultName,
propEnum.retentions, propEnum.owner };
// Properties used to get account class information for the owner
refProp ownerProps = new refProp();
ownerProps.refPropName = propEnum.owner;
ownerProps.properties = new propEnum[] { propEnum.searchPath, propEnum.defaultName };
// Declare sort properties for reports and users
//reports
sort[] reportSort = new sort[] { new sort() };
reportSort[0].order = orderEnum.ascending;
reportSort[0].propName = propEnum.defaultName;
// Set up query options for the call. Adding the packageProps
// will cause all requested subproperties to be retrieved for
// the properties listed that refer to other objects.
queryOptions qo = new queryOptions();
qo.refProps = new refProp[] { ownerProps };
// Declare search path for reports and for a single user, based on CAMID
searchPathMultipleObject objectsPath = new searchPathMultipleObject();
searchPathMultipleObject userPath = new searchPathMultipleObject();
//Set search paths to get reports. Userpath must be set
//separately for each individual based on CAMID
objectsPath.Value = "//reportView";
//objectsPath.Value = "/content/package[@name='National Accounts']/report[@name='(0226) NA Ebit by Customer/Minor Line - Combined']";
//objectsPath.Value = "CAMID(\"ADS:u:cn=miller\\, barret,ou=new,ou=groups,ou=general,ou=tyson team members\")/folder[@name='My Folders']/reportView[@name='Report View of (0224) Combined Sales']";
// Run query to get all reports. Users will be queried as part of this
// process, one for each report.
baseClass[] bc = cCMS.query(objectsPath, reportProps, reportSort, qo);
if (bc.Length > 0)
{
foreach (baseClass report_item in bc)
{
// Cast base class object to more specific report object for access to more
// properties
if (report_item is reportView)
{
cognosdotnet_2_0.reportView reportv = (cognosdotnet_2_0.reportView)report_item;
foreach (retentionRule rule in reportv.retentions.value)
{
// If the rule is for the type 'reportVersion' and has the duration set
if ((rule.objectClass == classEnum.reportVersion) && (rule.maxDuration != null))
{
// Output the name
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.defaultName.value;
//Increment the column count
cellCount[1]++;
//Output the path
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.searchPath.value;
//Increment the column count
cellCount[1]++;
if (reportv.owner.value == null)
{
oSheet.Cells[cellCount[0], cellCount[1]] = "unknown";
}
else
{
oSheet.Cells[cellCount[0], cellCount[1]] = reportv.owner.value[0].defaultName.value;
}
//Reset the column count, and increment the row count
cellCount[1] = 1;
cellCount[0]++;
}
}
}
}
}
return true;
}