Hi , Request you share me the Inforamtion. Thanks, Raju N R Raju

Hi , I have given SQL query is below. I am able to generate report, now i am able to see in the report all software application name and computer name and usersname ( all user profiles) and count.problem is while generating report it is giveing all system login user profiles. My requirment is it has has to genarate report for all software apllication name and System Name and lost logon user name and last software scaned date and time and count of the application. Request you share me the Inforamtion. Thanks, Raju N R Raju

I want write new query from SCCM Data base. Hi, How to write new Sql query. Requirement is All installed application Name and Computer Name and last loged user name and last scaned software date and time. Thanks, NRR N R Raju

Hello - You can start writting the reports with the help of below blog post from John? http://myitforum.com/cs2/blogs/jmarcum/archive/2011/05/19/157675.aspx There are lot of discussion about the same type of query in this forum.Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

Can you show us, what you have written so far. It's often easier to help, if you have an existing statement.Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund

Some examples can be found in the below thread http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/3046d813-83fa-43d6-8454-3f0de1ff9798Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

Hi, Do you want the query per machine, per collection or for all systems? a report for all systems with that critieria will be huge and perhaps not a good idea. Regards, Jörgen -- My System Center blog ccmexec.com --

Hi , I have given SQL query is below. I am able to generate report, now i am able to see in the report all software application name and computer name and usersname ( all user profiles) and count.problem is while generating report it is giveing all system login user profiles. My requirment is it has has to genarate report for all software apllication name and System Name and lost logon user name and last software scaned date and time and count of the application. Request you share me the Inforamtion. Select Distinct v_LU_SoftwareList_EDITABLE.tag3name as "Software Group Level 1", v_LU_SoftwareList_EDITABLE.tag1name as "Software Group Level 2", v_LU_SoftwareList_EDITABLE.tag2name as "Software Group Level 3", v_LU_SoftwareList_EDITABLE.commonname as "software Product", v_R_System_Valid.Netbios_Name0 AS "Computer Name",Count(Distinct NormalizedName) as "Count", v_R_User.lastusername0 FROM v_GS_INSTALLED_SOFTWARE_CATEGORIZED INNER JOIN v_R_System_Valid on v_R_System_Valid.ResourceID = v_GS_INSTALLED_SOFTWARE_CATEGORIZED.ResourceID inner join v_LU_SoftwareList_EDITABLE on v_LU_SoftwareList_EDITABLE.softwareid = v_GS_INSTALLED_SOFTWARE_CATEGORIZED.softwareid inner join v_GS_CCM_RECENTLY_USED_APPS v_R_User on v_R_User.ResourceID = v_R_System_Valid.resourceid where v_LU_SoftwareList_EDITABLE.tag3name is not null Group By v_LU_SoftwareList_EDITABLE.tag3name, v_LU_SoftwareList_EDITABLE.tag1name, v_LU_SoftwareList_EDITABLE.tag2name, v_LU_SoftwareList_EDITABLE.commonname, v_R_System_Valid.Netbios_Name0 , v_R_User.lastusername0 Order by v_LU_SoftwareList_EDITABLE.tag3name, v_LU_SoftwareList_EDITABLE.tag1name, v_LU_SoftwareList_EDITABLE.tag2name, v_LU_SoftwareList_EDITABLE.commonname, v_R_System_Valid.Netbios_Name0 Thanks, RajuN R Raju

Hi, i want query for all systems or collection. Thanks, Raju Raju

Have you gone through the thread I have provided? Was that helpful?Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.