Re: How to get the all unauthorized installed applications in my pc? - C# Discussion Boards

29-May-12 11:35

Hi,

Everything I've googled says this should work, but I get "invalid namespace" and was wondering if someone can help me get a baseline going so that I can build off of that?

I have the necessary references/includes, I just cannot get this to work for the life of me. Thanks for reading.

string cServername = "[server]";

System.Management.ConnectionOptions objconn = new System.Management.ConnectionOptions();
            objconn.Impersonation = System.Management.ImpersonationLevel.Impersonate;
            objconn.EnablePrivileges = true;
            objconn.Username = "[user]";
            objconn.Password = "[pass]";
            objconn.Authority = "ntlmdomain:[domain]"; 
            
            
            System.Management.ManagementScope exmangescope = new System.Management.ManagementScope(@"\\" + cServername + @"\root\MicrosoftExchangeV2", objconn);
            System.Management.ObjectQuery objquery = new System.Management.ObjectQuery("SELECT * FROM Exchange_Mailbox");
            System.Management.ManagementObjectSearcher objsearch = new System.Management.ManagementObjectSearcher(exmangescope, objquery);
            System.Management.ManagementObjectCollection queryCollection1 = objsearch.Get();
            string strDisplay;
            foreach (System.Management.ManagementObject instmailbox in queryCollection1)
            {
                strDisplay = instmailbox["MailboxDisplayName"].ToString() + " " + instmailbox["size"].ToString();
                System.Console.WriteLine(strDisplay);
            }

Dave Kreskowiak29-May-12 18:15

29-May-12 18:15

It's simple, really. The namespace you're specifing doesn't exist on the target machine.

Use this[^] to show you what namespaces are on the target machine.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

turbosupramk330-May-12 3:39

30-May-12 3:39

Thanks for that Dave, here is the output:

PS C:\Users\> gwmi -namespace "root" -class "__Namespace" | Select Name

Name
----
subscription
DEFAULT
QuestSoftware
MicrosoftDfs
CIMV2
Cli
Nap
MicrosoftIISv2
MicrosoftActiveDirectory
SECURITY
SmsDm
snmp
RSOP
ccm
WMI
IntelNCS2
directory
Policy
Hardware
ServiceModel
Microsoft
aspnet

I guess Exchange doesn't have database entries? If that turns out to be the case, what is the next best way to get individual user mailbox statistics?

Dave Kreskowiak30-May-12 4:22

30-May-12 4:22

That depends on the version of Exchange you're talking about.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

turbosupramk330-May-12 4:32

30-May-12 4:32

Good point Smile | :)

, 2007 sp3

Dave Kreskowiak30-May-12 5:19

30-May-12 5:19

Fist, take a look at this[^] and this[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

turbosupramk330-May-12 5:38

30-May-12 5:38

Hi Dave,

I can't use the shell, it takes far too long to instantiate a work space for powershell or for the exchange shell.

I found something for EWS, but I cannot get it to work (it may only work on 2010) so that I can start tweaking it.

http://stackoverflow.com/questions/2568624/how-do-i-get-folder-size-with-exchange-web-services-2010-managed-api/10819544#10819544[^]

This also looked promising, but does not compile

http://jwillmer.de/blog/2012/02/21/work-with-exchange-web-services/comment-page-1/#comment-45[^]

modified 30-May-12 12:03pm.

Dave Kreskowiak30-May-12 7:05

30-May-12 7:05

Does your Excahnge implementation have EWS 2007 installed? If not, this isn't going to work at all.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

turbosupramk330-May-12 7:40

30-May-12 7:40

Hi Dave,

Yes, I am able to enumerate the folder names now and get the item count for each folder, but I cannot figure out how to convert the folder names to an item list to try and load the extended properties for each folder name.

turbosupramk330-May-12 9:28

30-May-12 9:28

Update:

I'm able to get it working, but only for my own mailbox? Any ideas? I can get it to attempt other users, but I get a permissions error. I'm an exchange org admin and full admin so I'm not sure why that would be?

 private static readonly ExtendedPropertyDefinition PidTagMessageSizeExtended
                        = new ExtendedPropertyDefinition(0xe08, MapiPropertyType.Long);

private void button1_Click(object sender, EventArgs e) // test
        {

            ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2007_SP1);

        
            //Change the Credentials to suit you needs
            service.Credentials = new WebCredentials("[account]", "[password]", "[domain]");
            

            //Use Autodiscover or Set the URL manually. Change the email address to match yours
            service.AutodiscoverUrl("emailaddress@domain.com");
            
            int moffset = 0;
            int mPageSize = 500;
            FolderView view = new FolderView(mPageSize, moffset, OffsetBasePoint.Beginning);

            // Identify the properties to return in the results set.
            view.PropertySet = new PropertySet(BasePropertySet.IdOnly);
            view.PropertySet.Add(FolderSchema.DisplayName);
            view.PropertySet.Add(FolderSchema.ChildFolderCount);
            view.PropertySet.Add(FolderSchema.TotalCount);
            view.PropertySet.Add(FolderSchema.UnreadCount);
            
            // Unlike FindItem searches, folder searches can be deep traversals.
            view.Traversal = FolderTraversal.Deep;//.Shallow;
            //FindFoldersResults folders = service.FindFolders(WellKnownFolderName.MsgFolderRoot, view);
            FindFoldersResults folders = service.FindFolders(WellKnownFolderName.MsgFolderRoot, view);


            var offset = 0;
            const int pagesize = 500;
            long size = 0;

            FindFoldersResults foldersNew;
            do
            {
                foldersNew = service.FindFolders(WellKnownFolderName.MsgFolderRoot,
                                              new FolderView(pagesize, offset, OffsetBasePoint.Beginning)
                                              {
                                                  Traversal = FolderTraversal.Deep,
                                                  PropertySet =
                                                      new PropertySet(BasePropertySet.IdOnly, PidTagMessageSizeExtended,
                                                                      FolderSchema.DisplayName)
                                              });
                foreach (var folderNew in foldersNew)
                {
                    object folderSize;
                    if (folderNew.TryGetProperty(PidTagMessageSizeExtended, out folderSize))
                    {
                        //Console.Out.WriteLine("{0}: {1:00.00} MB", folderNew.DisplayName, folderSize / 1048576);
                        int bytes = Convert.ToInt32(folderSize);
                        int megaBytes = (bytes / 1048576);
                        size += megaBytes;
                        MessageBox.Show(folderNew.DisplayName + ": " + megaBytes + ", total mailbox size: " + size);
                    }
                }
                offset += pagesize;
            } while (folders.MoreAvailable); 
}

modified 30-May-12 16:54pm.

turbosupramk330-May-12 11:51