Sana

Yep, Figured that they won't save under RP directory. I meant to ask, is there a recommended location for the Virtual directory which is specified under report manager URL section? Thanks!!

Hello, I have been creating custom reports in SCCM using SSRS for a few months now. Just today, I was trying to back up all the reports and I can't find the custom reports folder under my **/Program Files/SMS_SRSRP/Reports folder. Are they saved under a different location? Thanks in advance!!! Sana

Hi.. I'm in a weird situation . This morning we found out our primary 1 has lost many desktops(75% of the company systems) from the console(do not know the exact reason yet). So at the end of the day we started recovering the primary 1(site server and data base) with the backups and it was successful. We were about to say woohoo, lets wrap it up and go home ...But As soon as the primary 1 restored all the data from backup files, CAS started replicating the current data (25% data) making the primary go back to the messed up state. Now, we do not want to recover the CAS and the primary 2 to bring the primary 1 up. It will be very helpful to know, if there are any other options left for me to try(before the sun rise). Any help Thanks Sana

Hi Eswar, I want to generate a list of users the app is targeted to and their machines where this application is installed on. I have created this below report which is giving some information but i'm not quite sure where this is coming from exactly as it is not accurate. SELECT DISTINCT ada.CollectionName, ada.MachineName, ada.UserName, ass.displayname FROM vAppDeploymentAssetData as ada INNER JOIN vAppStatSummary as ass ON ada.AppCI = ass.AppCI INNER JOIN vUsersPrimaryMachines as upm ON ada.MachineID = upm.MachineID WHERE ass.DisplayName LIKE @AppName Thanks Much!!! Sana

Hi, I'm fairly new to SSRS . I'm trying to create a custom report which should give me a list of users for a specific application deployment(User based collection). Any help is greatly appreciated. Thanks much!! Sana

I figured out what's goin on. This errors are caused by the numerous AD loops in our environment(Huge binary values). Which we have to live with for next few months.

This will help. Run Vssadmi list writers on the srver and see which ones failed. In my case Sql server writer and sms writer failed. I had to update the logon account details for sql server writer from system account to admin account nd restart the service. Also changed the backup schedule. This worked for me.

Were you able to fix this issue? What was the problem? Can you please post the resolution.

Here are the contents of ddr file.. This is for users. FV° ) <User> BEGIN_PROPERTY <8><Unique User Name><19><32><rrr\kyuyu> END_PROPERTY BEGIN_PROPERTY <0><User Name><19><32><kyuyu> END_PROPERTY BEGIN_PROPERTY <0><Full User Name><19><32><kyuyu> END_PROPERTY BEGIN_PROPERTY <0><Windows NT Domain><19><32><rrr> END_PROPERTY BEGIN_PROPERTY <0><Full Domain Name><19><32><CORP.yuyuyuyuy.C OM> END_PROPERTY BEGIN_PROPERTY <0><Distinguished Name><19><96><CN=kyuyu,OU=Standard,OU=Users,OU=La Mesa,OU=rrr Sites,DC=corp,DC=yuyuyuyuy,DC=com> END_PROPERTY BEGIN_PROPERTY <0><Network Operating System><19><32><Windows NT> END_PROPERTY BEGIN_PROPERTY <17><User OU Name><19><96> BEGIN_ARRAY_VALUES <CORP.yuyuyuyuy.COM/rrr SITES><CORP.yuyuyuyuy.COM/rrr SITES/LA MESA><CORP.yuyuyuyuy.COM/rrr SITES/LA MESA/USERS><CORP.yuyuyuyuy.COM/rrr SITES/LA MESA/USERS/STANDARD> END_ARRAY_VALUES END_PROPERTY BEGIN_PROPERTY <17><User Container Name><19><96> BEGIN_ARRAY_VALUES END_ARRAY_VALUES END_PROPERTY BEGIN_PROPERTY <0><Primary Group ID><8><4><513> END_PROPERTY BEGIN_PROPERTY <0><User Account Control><8><4><512> END_PROPERTY BEGIN_PROPERTY <0><SID><19><64><S-1-5-21-1751263204-1070006853-2113807418-142364> END_PROPERTY BEGIN_PROPERTY <0><Object GUID><3><16><0x612663F144ABD54E816A641FF7C0EBEB> END_PROPERTY BEGIN_PROPERTY <0><Mail><19><32><uuuu@kkkkkk.com> END_PROPERTY BEGIN_PROPERTY <8><User Principal Name><19><32><kyuyu@corp.yuyuyuyuy.com> END_PROPERTY BEGIN_PROPERTY <0><title><19><64><Preferred Office Management> END_PROPERTY BEGIN_PROPERTY <0><department><19><32><Preferred Offices> END_PROPERTY BEGIN_PROPERTY <0><extensionAttribute4><19><32><Employee> END_PROPERTY AGENTINFO<SMS_AD_USER_DISCOVERY_AGENT><FR1><08/15/2014 07:20:01> FEOF FV

Hi, I am seeing this critical error on my primary. SMS_DISCOVERY_DATA_MANAGER Message ID 2636 and 620. Every time its a new DDR and there are tons of them. Discovery Data Manager failed to process the discovery data record (DDR) "D:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\userddrsonly\adu65oa0.DDR", because it cannot update the data source. Possible cause: On a Primary site, it is probably a SQL Server problem. Solution: 1. Review the immediately preceding status messages from this component about SQL Server errors. 2. Verify that this computer can reach the SQL Server computer. 3. Verify that SQL Server services are running. 4. Verify that the site can access the site database. 5. Verify that the site database, transaction log, and tempdb are not full. 6. Verify that there are at least 50 SQL Server user connections, plus 5 for each Configuration Manager Console. If the problem persists, check the SQL Server error logs. Possible cause: On a secondary site, Discovery Data Manager probably cannot write to a file on the site server, so check for low disk space on the site server. Solution: Make more space available on the site server. I have checked Configuration Manager\inboxes\auth\ddm.box\userddrsonly\BAD_DDRS folder and found out that there are a bunch of ddr files in there. I am not sure if I can delete them or not. So I moved them to a temp folder. I am also monitoring DDM.log and adusrdis.log. I saw no errors on adusrdis.log but I saw a couple of error messages in ddm.log for the users the ddr files were created. DDM.log QL>>>With SubTable(ItemKey, [sMS_Resident_Sites0]) AS ( SELECT ItemKey, [sMS_Resident_Sites0] FROM [system_SMS_Resident_ARR] WHERE ItemKey = 2097172281 ) MERGE INTO SubTable AS Target USING (SELECT DISTINCT 2097172281, [sMS_Resident_Sites0] FROM (VALUES (N'AAA')) AS tempSourceTable([sMS_Resident_Sites0])) AS Source (ItemKey, [sMS_Resident_Sites0]) ON (Target.ItemKey = Source.ItemKey AND Target.[sMS_Resident_Sites0] = Source.[sMS_Resident_Sites0]) WHEN NOT MATCHED BY TARGET THEN INSERT (ItemKey, [sMS_Resident_Sites0]) VALUES (Source.ItemKey, Source.[sMS_Resident_Sites0]) WHEN NOT MATCHED BY SOURCE AND (Target.ItemKey = 2097172281) THEN DELETE ; SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 10324 (0x2854) SQL>>>update User_DISC set DiscArchKey = 4, title0 = N'Preferred Banking Offices Management', extensionAttribute40 = N'Employee' where ItemKey = 2063598788 SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC) *** [22001][8152][Microsoft] [sql Server]String or binary data would be truncated. SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)CDiscoverySource_SQL::UpdateItem - could not execute sql- update User_DISC set DiscArchKey = 4, title0 = N'Preferred Banking Offices Management', extensionAttribute40 = N'Employee' where ItemKey = 2063598788 SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC) CDiscoverDataManager::ProcessDDRs - Unable to update data source SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC) uuSTATMSG: ID=2636 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_DISCOVERY_DATA_MANAGER" SYS=abcdefgh.corp.xxxxxxxxxx.com SITE=AAA PID=2800 TID=9644 GMTDATE=Thu Aug 14 17:15:04.324 2014 ISTR0="D:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\userddrsonly\adu9yyx1.DDR" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC) Moving bad file adu9yyx1.DDR to D:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\userddrsonly\BAD_DDRS\adu9yyx1.DDR. SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC) CDiscoverDataManager::ProcessUserDDRs_PS - Moved bad DDR SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC) CDiscoverDataManager::ProcessUserDDRs_PS - error encountered. Stopping for 1 minute(s) SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC) CDiscoverDataManager::THREAD_ProcessUserDDRs - Failed to manage files in inbox. Will retry in at least 60 seconds SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC) SQL>>>>> Done. SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 10324 (0x2854) Any thoughts? Thanks!!!! UK

Updating the distribution point worked for some of those failed applications. But few of them struck at waiting status. When I checked cache the source was not downloaded completely. I tried creating new advertisements but it did not help. Same hing happening again and again. What should I do now? Thanks Sana

Yes. I did.

They failed with hash mismatch error.

Yes. I advertised the application on 02/10/2012 10:42AM and it showed up on the client at 6:27AM 02/11/2012. Execmgr.log shows the same time as the report.

The advertised applications finally showed up on my client but it took more tahn 1 day for this. Is there any partular reason behind that? How can reduce that time?